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

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