Nesting Excel formulas- VLOOKUP, IF,MATCH = confused

I have two sheets of raw data on one workbook. The goal is to match the "Rep Name" in sheet one: "Master", Column E, Rows 3-138 to "Delivery Name" in sheet two "Tracking Numbers", Column H, Rows 2-22. If there is a match, then I would like the cell to return the "Tracking Number" found in sheet two"Tracking Numbers", Column I, Rows 2-22 and place it into sheet one "Master", Column N, Rows 2-22. If there is no match, then I would like the field to be left blank.

I've eliminated duplicate names on the "Master" sheet so it should be looking 1:1. Sheet two "Tracking Numbers" is attached to a query that pulls data from Dynamics AX 2009, so the number of rows will change in the future depending on the number of tracking numbers. For the purposes of figuring this problem out, the connection to the database has been disconnected.


I believe I need a combination of MATCH, IF and VLOOKUP.


Here's how I verbally work through what I need:
IF the rep name = delivery name, then return the tracking number.

If rep name does not equal delivery name, then return blank space.

This is the formula I worked out, but I'm missing something somewhere (obviously):IF((MATCH(E23,'Tracking Numbers'!$H$2:$H$22,8)),VLOOKUP(E23,'Tracking Numbers'!$H$2:$H$22,9,FALSE),0),'Tracking Numbers'!$I$2:$I$22," "))

Any input and assistance is greatly appreciated. I think I have the equation correct in my brain, but I can't get the formulas to mimic my logic.

Thank you in advance!

I hope the attachment works--

Simplifying the equation:

If MasterA = TrackingNumbersA, then take data from TrackingNumbersB and show in MasterB.

If MasterA does not equatl TrackingNumbersA, show blank or NA in MasterB.

Let me know if there is any more info I can provide, and thank you in advance!

Dylan,

Not entirely sure I understood your last post... Will the attached help? Just copy the formula in cell B2 (on the "Master" tab) down the length of the data in col. A.

If I'm on the wrong track let me know and I'll give it another go.

Steve

Okay, I did a VLOOKUP formula to get the results (except I'd prefer the #NA to be blank, but I think I have the IF formula for that written elsewhere).

I guess were I'm getting confused is the actual spreadsheet contains a lot more data, which I usually hide, so maybe I just extract the data I need, paste the info to a new spreadsheet, and do a simple VLOOKUP??

Maybe I'm overthinking the whole thing?

Are you a wizard of some kind? It works! I think I was over complicating it in my mind because the original spreadsheets has more information than necessary to complete the task at hand. I should just keep it simple, (stupid)!

I'm going to test it on the master spreadsheet and see if I can apply it.

Thank you!

Excellent! If you have any questions about the "Table" in the 'Tracking Numbers' sheet and how it is used in the formula - hit me back.