Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help with Lookups?
I am trying to find a formula/Function that will help me do the following.
Table. Column A: List of Names Column B: Numerical Values Column C: List of Names Column D: Empty A function that will fill in Column D with a Numerical Value found in Column B where Column A = Column B. Example Data. Column A Row 1 Jimmy Row 2 Steve Column B Row 1 '4' Row 2 '8' Column C Row 1 Steve Row 2 Jimmy Column D Row 1 Empty Row 2 Empty After putting in this formula Column D should look like Row 1 '8' Row 2 '4' Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
V Lookups | Excel Discussion (Misc queries) | |||
Excel Formula for multiple lookups | Excel Discussion (Misc queries) | |||
need help with V lookups | Excel Worksheet Functions | |||
Max and lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |