Is this possible using the Vlookup or any other function?

		Microsoft Office Forums > Microsoft Excel > Excel
Is this possible using the Vlookup or any other function?

02-08-2010, 01:27 PM

ConneXionLost ConneXionLost is offline

Windows XP Is this possible using the Vlookup or any other function?

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

Hi Delson,

Try this:

Code:

=IF(ISNA(MATCH(A21,Sheet2!$I$2:Sheet2!$I$6498,0)),"Not in List",VLOOKUP(A21,Sheet2!$I$2:Sheet2!$L$6498,4,0))

Cheers,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
vlookup question	Tony G	Excel	9	03-28-2009 11:16 PM
Vlookup and If statement problem	bunnygum	Excel	1	03-24-2009 05:10 AM
Need help on what function to use???	Primeraman	Excel	1	06-13-2006 10:16 AM
Help with Combination function	sanasath	Excel	0	12-13-2005 07:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:23 AM.