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

Thread: Using IF & VLOOKUP together

View Single Post

Old

11-17-2010, 05:09 PM

Kimberly

Kimberly is offline

Kimberly uses Windows 7

Windows 7

Kimberly uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

I happened to notice a tiny typo. Try this
=IF(ISNA(VLOOKUP(F2,'[PickList(1).xls]Pick'!$D$2:$G$9,4,0)),0,VLOOKUP(F2,'[PickList(1).xls]Pick'!$D$2:$G$9,4,0))

Reply With Quote