Microsoft Office Forums - View Single Post - Using IF & VLOOKUP together

Thread: Using IF & VLOOKUP together

View Single Post

Old

11-17-2010, 01:53 PM

pdab09

pdab09 is offline

pdab09 uses Windows XP

Windows XP pdab09 uses Office 2007

pdab09 uses Office 2007

Office 2007

Novice

Join Date: Nov 2010

Posts: 6

pdab09 is on a distinguished road

Default

Thought my original lookup was a bit top heavy and it later occurred to me that half of it isn't needed. Try this one in H6 instead.

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

Reply With Quote