Using IF & VLOOKUP together

		Microsoft Office Forums > Microsoft Excel > Excel
Using IF & VLOOKUP together

FAQ

Thread Tools

Display Modes

11-17-2010, 05:09 PM

Kimberly

Windows 7

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
Vlookup Examples Please ?????	AmrMahmoud1982	Excel	2	10-10-2010 06:31 PM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM
vlookup question	Tony G	Excel	9	03-28-2009 11:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.