Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |