Is this possible using the Vlookup or any other function?

FraserKitchell · #1 02-05-2010, 11:18 AM

This sounds very doable. Can you post a small example? Thanks,

Fraser

Delson · #2 02-08-2010, 02:24 AM

I have almost cracked it by using parts of formulas i found on other threads. I am using the following formula

=IF(ISERROR(VLOOKUP(A21,Sheet2!$I$2:Sheet2!$J$6498 ,2,0)),"Not in List",VLOOKUP(A21,Sheet2!$I$2:Sheet2!$J$6498,2,0))

However i also want to display the values in col L, how would i change this formula to show those values?

FraserKitchell · #3 02-08-2010, 11:22 AM

I'm still not sure what exactly you are trying to do...displace column L in a seperate cell or in the same cell. Since these are both text values, you might be looking for a =CONCATENATE( function, which will splice text from two cells together.

ConneXionLost · #4 02-08-2010, 01:27 PM

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