This is probably simple and I am making it more difficult than it should be. What I have is a document with 2 sheets. "Sheet 1" and "Sheet 2" for example. One is reference data. On both sheets I have serial numbers. On sheet 2, I have a list price. There are 130000 rows, so I can't do it manually.

What I need is to match the two serial numbers and, if there is a match, return the list price. I know this is probably a fairly simple situation, but I am having problems with it.

Anyone help?
Say Serial Number is Column A in Sheet 1, Column Z in Sheet 2. List Price is column CX in Sheet 2.

Thank you so much!!