Need Help with Vlookup with 2 workbooks and results in 3rd as a vba macro?

[ucsutah]

Hi,

your help would be much appreciated.

I have workbook datafeed.xls on column I my cost and on that column has about 3000 other prices and on that workbook column b is the sku that needs to be matched. On another workbook named "markup" it has on column A markup and then on column B to mark it up by. So lets say the cost is $2.35 then on the look up table would be 2.35 X 6.5 or if it was 5.89 it would be 5.89 X 3.5. (On table below) I need to output the results in a 3rd workbook called result.xlsx on column J2 but must match sku on column b in result.xlsx.

thanks for your help

[Keebellah]

Good morning, I'm sure the question is quite clear to you but honestly, I cannot really make heads or tails out of your question.
I suggest you attach three simplified files with your data (non-private data please) and mark what you have and what you want.
You'll probably get a better answer and avoid the helpers making incorrect assumptions

[kev_]

This may help you do what is requested in above post

Remember to desensitize the data.

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