Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can someone help with a formula to return a value from this lookup.
I have created an example of the lookup I need. The target range is a range of (say) three columns. I want to lookup a value from the third column and return the value from the first cell in the corresponding row. eg three columns (A, B, C) 4 rows (1,2,3,4) Description Qty Code Desc A 3 1 Desc B 4 2 Desc C 2 3 Desc D 8 4 if the target is "3" I want to return "Desc C" if the target is "4" I want to return "Desc D" Thanks |