| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup returns n/a
Hi, can someone see where I am going wrong with this vlookup?
=VLOOKUP(Totals!F4,'Manufacturer Codes'!A8:I174,5,FALSE) Totals!f4= 3/8* Cheer 2.2 lb Prime Foam the exact match is in 'Manufacturer Codes' C70 ( 3/8* Cheer 2.2 lb Prime Foam ) the return I want is in 'Manufacturer Codes' G70 The formula is in Totals!F5 Thanks Todd |
|
#2
|
|||
|
|||
|
Try the following formula... =INDEX('Manufacturer Codes'!G8:G174,MATCH(Totals!F4,'Manufacturer Codes'!C8:C174,0)) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=275772 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
| Vlookup Syntax Error | New Users to Excel | |||
| Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
| Vlookup returns incorrect match | Excel Discussion (Misc queries) | |||
| Using Cell references in VLookUp | Excel Worksheet Functions | |||
Linear Mode
