Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup question
I have a range of cells where the first 4 columnd contain numeric data & the 5th column contains names in random order. I have a name value in another cell outside this range. I want to use this cell to find a name in my range of data and return the value in the first column for that name. I know a VLOOKUP will work where you match on the first column and return data from some other column, but waht do you do to lookup in the 5th column and return in the first column? Thanks Mike -- mwc0914 ------------------------------------------------------------------------ mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130 View this thread: http://www.excelforum.com/showthread...hreadid=378666 |
#2
|
|||
|
|||
=INDEX(A2:A100,MATCH(F1,E2:E100,0)) Ola Sandström -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=378666 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LookUp Type Question | Excel Worksheet Functions | |||
Lookup Question | Excel Worksheet Functions | |||
Formula Question... LookUP | Excel Discussion (Misc queries) | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Lookup Question | Excel Worksheet Functions |