phill wrote:
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


Hi Phill,

Have a look at this link:

http://www.contextures.com/xlFunctions02.html

Regards,
Bondi