multiple ranges on Vlookup
Try...
=IF(E2<"",VLOOKUP(E2,IF(ISNUMBER(MATCH(E2,'Code
Descrip'!T3:T27,0)),'Code Descrip'!T3:U27,'Code Descrip'!X3:Y48),2,0),"")
Hope this helps!
In article ,
lpj wrote:
I currently have my Vlookup stmnt as this:
=IF(E2="","",VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))
'Code Decrip' is the name of the worksheet
I need to add another range X$3:Y48
What is the proper syntax - I wasnt able to get it right after searching
online for it.
Thanks so much.
|