Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Any body pls help me.....?
Sheet1 A B C Name Rank Company Romeo Painter PWD Patrick Carpenter ABC Sheet2 D E F G H Name Result. Romeo PWD On Sheet2 (H2) How can I Lookup for Romeo from Sheet1(A1:A100) and place the corresponding value on C For example:- On Sheet2 D2(Sheet2) If I type Patrick how can I get a result on H2(Sheet2)ABC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup looks to the prior column if zero appears in the lookup col | 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) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |