Using a formula to populate a cell with certain data based on content of another cell

Hi.

I am currently trying to create a spreadsheet whereby if I enter certain text in a cell in Column A on worksheet 1 that correlates with text in a cell in Column A on Worksheet 2, then the description in Column B in Worksheet 2 is entered into Column B on worksheet 1. Does that make sense?

For example, if worksheet 2 has the following:

Column A Column B
XXXX PRODUCT 1
YYYY PRODUCT 2

and I enter XXXX in column A on worksheet 1, I want Column B on worksheet 1 to automatically enter PRODUCT 1.

Can anyone tell me the right formula? I have tried searching for it but I am having no joy.

Thanks in advance for any help.

Thanks for the quick reply. the only problem I have is that I have a range of 400 codes and their corresponding descriptions so I need to apply a range to the formula. I have been experimenting with the IF function but with no joy as yet.

If you have a table of these 400 codes, you should use a vlookup. I have attached an example of how they work, let me know if this will work for you.

The formula is in the Yellow cell, the value it is looking for is in B1. Type in B1 VVVV,WWWW,XXXX,YYYY or ZZZZ and cell A1 will change to match it's corresponding product number based on the green table.

Typo in the notes on this file, the 2 in the fomula is col_index_number, not lookup_table!

Thanks so much for your help guys. that has done exactly what I was wanting it to do.