| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
