Hi

Can anyone tell me what equation i need. i have two sheets in excel and i
have data in column A and B on sheet 1 column A is full or product codes and
B is the description. on sheet 2 the data is taken from column A on sheet 1
automatically. how can i get it to automatically look up the data from
column A on sheet 1 and then put the corresponding value in column B on sheet
2 from column B sheet 1.

Many thanks

Phill