Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Help, Please!
Help and Hello!
I'm trying to look up and match a value from each row in column A to a value in column C and return the associated value for that row in column B. Example: A B C D 14 0.1 14 0.1 14 0.1 15 0.2 15 0.2 16 0.3 15 0.2 17 0.5 16 0.3 18 0.8 Thanks so much in advance!!! Chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Help, Please!
Try one of these.
Entered in B1: =VLOOKUP(A1,C$1:D$5,2,0) =INDEX(D$1:D$5,MATCH(A1,C$1:C$5,0)) Copy down as needed. -- Biff Microsoft Excel MVP "Not Excelerated" wrote in message ... Help and Hello! I'm trying to look up and match a value from each row in column A to a value in column C and return the associated value for that row in column B. Example: A B C D 14 0.1 14 0.1 14 0.1 15 0.2 15 0.2 16 0.3 15 0.2 17 0.5 16 0.3 18 0.8 Thanks so much in advance!!! Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |