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?

FAQ

Thread Tools

Display Modes

02-08-2010, 02:24 AM

Delson

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

Office 2003

Novice

Join Date: Feb 2010

Posts: 2

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?

« 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 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 11:54 AM.