Pull info from sheet into another sheet.

[psoli]

Hi everyone, sorry if this has been done before a million times, but I've not been able to find anything on search and I need an answer reasonably sharpish for work.

Bit (read very) rusty with Excel, I need to match information in column A in sheet X, to the same information (part number) contained within a list in Column A on another sheet -Y, and when there is a match, pull information from the same row as the match from column B in sheet Y to B in sheet X.

Any help would be very much appreciated.

[royUK]

Sounds like VLOOKUP

[psoli]

Sorted, cheers!

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save