Thread: [Solved] Is this possible using the Vlookup or any other function?
View Single Post
 
Old 02-08-2010, 02:24 AM
Delson Delson is offline Windows XP Office 2003
Novice
  
Join Date: Feb 2010
Posts: 2
Delson is on a distinguished road
Default
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?
Reply With Quote