New to this forum so I apologize in advance if this question has been asked previously. Here goes....
On one sheet I have 400 item numbers that have corresponding categories. For example... item xxxxx in column A, sales category in column B.
On another sheet in the same workbook I have over 3000 item numbers that I need to put a list next to that displays the matching sales category located in column B of the first sheet.
I'm trying to figure out how to write a statement that says if one of the 3000 item numbers match one of the 300 item numbers in column A, then return the value in column B.
Thanks for the help!