Hi,

I was trying to create a formula. But its not working out.

This is what exactly I need to do. If the cell A1 contains "Test" B1
has to give "Test". If A1 does not contain "Test", then VLOOKUP the
first 19 characters in sheet 2 and give the corresponding value in B1.

The formula I have given is:

=IF(FIND("Test",A1,1),"Test",VLOOKUP(LEFT(A1,19),' sheet
2'!$A$1:$B$250,2,))

What may be wrong in this?

-Dileep