Thread: Using IF & VLOOKUP together
View Single Post
 
Old 11-17-2010, 09:32 AM
pdab09 pdab09 is offline Windows XP Office 2007
Novice
  
Join Date: Nov 2010
Posts: 6
pdab09 is on a distinguished road
Default
Try this in Cell H6 (of StockList.xls)

=IF(ISNA(VLOOKUP(F6,[PickList.xls]Pick!$D$2:$G$9,1,FALSE))=TRUE,0,IF(VLOOKUP(F6,[PickList.xls]Pick!$D$2:$G$9,1,FALSE)=F6,VLOOKUP(F6,[PickList.xls]Pick!$D$2:$G$9,4,FALSE),""))

Seems to do the trick though I'm sure there are neater ways!
Reply With Quote