ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP (https://www.excelbanter.com/excel-discussion-misc-queries/90620-vlookup.html)

Teaster

VLOOKUP

Hi
My vlookup is as follows
Pull down inventory (b18) comes back with sell price (3) Sell cost
=IF(ISBLANK(B18),"",VLOOKUP(B18,ProductInfo,3,FALS E))

Problem I am having:
Will not go past (3) on my productinfo.. I have the next col set up for
profit (4)
=IF(ISBLANK(B18),"",VLOOKUP(B18,ProductInfo,4,FALS E))
comes back as #ref
Ugh...

Thanks a head of time for any input

Toppers

VLOOKUP

This suggests "ProductInfo" is incorrect - how is it defined?

"Teaster" wrote:

Hi
My vlookup is as follows
Pull down inventory (b18) comes back with sell price (3) Sell cost
=IF(ISBLANK(B18),"",VLOOKUP(B18,ProductInfo,3,FALS E))

Problem I am having:
Will not go past (3) on my productinfo.. I have the next col set up for
profit (4)
=IF(ISBLANK(B18),"",VLOOKUP(B18,ProductInfo,4,FALS E))
comes back as #ref
Ugh...

Thanks a head of time for any input

All times are GMT +1. The time now is 01:12 AM.