Need help with data matching

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

try it now

ok, what is your real version of Excel? For sure not a 2003. Update your profile about your version.

updated its 2010

what is 6,7,8,9 on top of the data tab?

extra disregard not sure why its in there

I am not sure also
but you can use PowerQuery

Power Query for

• Excel 2010 Pro Plus or Excel 2013 Pro Plus can be downloaded as free add-in from MS site (choose correct version). I suggest Power Pivot also
• Excel 2016 or Excel 365 is built-in, aka Get&Transform
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What PowerQuery is? see here: Getting Started with PowerQuery (Get&Transform) in Excel

so the reason I posted this is because i'm unable to download anything on the company computer thank you though

maybe someone else will give you a formula solution

have a nice day

I posted your thread on Call in the Cavalry so maybe soon someone will do that for you

Thank this was what I need! I appreciate it! I just had to adjust a few points but over all its what I needed thank you

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.