VLOOKUP

[Teaster]

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,FALSE))

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,FALSE))
comes back as #ref
Ugh...

Thanks a head of time for any input

[Toppers]

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,FALSE))
>
> 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,FALSE))
> comes back as #ref
> Ugh...
>
> Thanks a head of time for any input
>