Hi
have a look at the VLOOKUP function. See:
http://www.contextures.com/xlFunctions02.html

"mjh" wrote:

I require assistance in setting up a solution and I will try and explain the
situation clearly.

I have a workbook with three worksheets.

Column A in sheets 2 and 3 will have 'some' of the values that appear Sheet
1's column A, however not necessarily in the same row.

In sheet 2 and 3 each value in column A will have a corresponding value in
Column B on the same row.

I need to have excel search column A of sheets 2 and 3, place the
corresponding value of column B in beside the matching value in sheet 1,
column A

Any help will be appreciated. I hope I explained my situation clear enough!

Thank you