Using IF & VLOOKUP together

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

FAQ

Thread Tools

Display Modes

11-18-2010, 05:15 AM

junction

Windows Vista Using IF & VLOOKUP together

Office 2003

Novice

Join Date: Nov 2010

Posts: 2

Thank you both for your help.

I've had to ammend the forumla slightly as I had to strip down both the spreadsheets in order to upload them (too big!).

This is the formula I now have:

=IF(ISNA(VLOOKUP(F6,[Picklist1.xls]Pick!$D$2:$H$493,1,FALSE))=TRUE,0,VLOOKUP(F6,[Picklist1.xls]Pick!$D$2:$H$493,4,FALSE))

Thanks again

« 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 07:42 AM.