Workbook1
Sheet1
A
1 car
2 boat
3 plane
4 train
5 motorbike

Workbook2
Sheet1
A B
1 moterbike formula returns €œmotorbike€�
2 car formula returns €œcar€�
3 lorry formula returns €œno match found€�

The formula looks in workbook1 and returns the same value as that displayed
in colA. If no match is found then display message.