Hi Kassis,

I this a typo on the first line?

=IF(E2="","",IF(ISERROR(VLOOKUP('Code
Descrip'!T$3:U$27,0,FALSE)),VLOOKUP(E2,'Code
Descrip'!X$3:Y$48,2,FALSE),VLOOKUP(E2,'Code Descrip'!T$3:U$27,2,FALSE))

Should be

=IF(E2="","",IF(ISERROR(VLOOKUP(E2,'Code
etc...

Regards,
Howard

"lpj" wrote in message
...
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.