If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup for this?
Hi,
In col A I have numbers 1 to 500 in sequential order In column B, I have values against each of these numbers In column C I have numbers 1 to 500 in non-sequential order In column D I want to match each number in column C with its equivalent in column A and return the corresponding variable in column B to column D For example, I have 8 in cell B25 and 25 in C1 and want to return 8 in D1 I have 15 in B107 and 107 in C2 and want to return 15 in D2 etc Do I use LOOKUP, VLOOKUP etc for this or something else? Can you give me an example of the formula? Many thanks. |
#2
|
|||
|
|||
Lookup for this?
"Zakynthos" wrote:
Do I use LOOKUP, VLOOKUP etc for this or something else? You can make either work. But in your case, the simplest might be: put the following formula into D1 and copy down: =vlookup(C1,$A$1:$B$500,2) However, you might not need column A if your numbers are always sequential starting with 1, 2 etc. In that case, you might consider: =index($B$1:$B$500,C1) ----- original message ----- "Zakynthos" wrote: Hi, In col A I have numbers 1 to 500 in sequential order In column B, I have values against each of these numbers In column C I have numbers 1 to 500 in non-sequential order In column D I want to match each number in column C with its equivalent in column A and return the corresponding variable in column B to column D For example, I have 8 in cell B25 and 25 in C1 and want to return 8 in D1 I have 15 in B107 and 107 in C2 and want to return 15 in D2 etc Do I use LOOKUP, VLOOKUP etc for this or something else? Can you give me an example of the formula? Many thanks. |
#3
|
|||
|
|||
Lookup for this?
Thanks, very helpful, I'll give it a try!
"Joe User" wrote: "Zakynthos" wrote: Do I use LOOKUP, VLOOKUP etc for this or something else? You can make either work. But in your case, the simplest might be: put the following formula into D1 and copy down: =vlookup(C1,$A$1:$B$500,2) However, you might not need column A if your numbers are always sequential starting with 1, 2 etc. In that case, you might consider: =index($B$1:$B$500,C1) ----- original message ----- "Zakynthos" wrote: Hi, In col A I have numbers 1 to 500 in sequential order In column B, I have values against each of these numbers In column C I have numbers 1 to 500 in non-sequential order In column D I want to match each number in column C with its equivalent in column A and return the corresponding variable in column B to column D For example, I have 8 in cell B25 and 25 in C1 and want to return 8 in D1 I have 15 in B107 and 107 in C2 and want to return 15 in D2 etc Do I use LOOKUP, VLOOKUP etc for this or something else? Can you give me an example of the formula? Many thanks. |
Thread Tools | |
Display Modes | |
|
|