[aaddison]

HELP! HELP! HELP!

I'm trying to pull multiple Excel spreadsheets into one master file. The multiple spreadsheets contain like information in column A, but may have different information in columns B,C,D,E etc. I need Excel to reference column A from the master file and pull the like items from the multiple columns contained in the other files and have that info applied to the master file matching up with the like items in column A.

(Note) The multiple files are not always formatted the same and if multiple files have the same data I want it to pull only the lowest number between the multiple files.

[slurpee55]

Welcome to the Forum!!
(Just for future reference, please use a slightly more descriptive title for your posts )
This is similar to something I was working on recently with someone else, AJ_old. It can be swiftly done using VBA - I will see if he (or another coder) is around.

[aaddison]

I'd appreciate that very much. It's been drive me slightly insane….as you can probably tell by my title.

[slurpee55]

I sent a note to one coder but his mailbox was full...I will look for others.

[aaddison]

Thank you! If you need a sample workbook let me know and I'll post one.

[Aj_old]

Hi aaddison!
To be easier to understand your need can post a sample file!
You have multiple Workbook, with information, and wanna combine then into one, ore have one workbook, with multiple sheets and wanna to combine then into single sheet?

[aaddison]

Both of your scenarios question are possible. Though the example spreadsheet that I’ve posted show's one workbook, however, there maybe cases were I’ll need to bring multiple workbooks into a master list.

[Aj_old]

aaddison what do you mean by "I need Excel to reference column A from the master file and pull the like items from the multiple columns contained in the other files and have that info applied to the master file matching up with the like items in column A."?
Not sure I understand you right!

[slurpee55]

Welcome to the problem AJ! Way over my head....

[aaddison]

I need the information (that's in the sheet labeled "master file") filled in matching up with the information from the other sheets. In the master file sheet I need the columns to reflect the lowest prices from each sheet (Texas,Florida) and also bring in the location, plus any other info from the other columns past that. Basically, I need the part#'s from the "master file" to match up with the other sheets part #'s and then grab all the columns associated with that part # and pick the lowest price in each column and apply it in the "master file". Am i still confusing?

[Aj_old]

Originally Posted by aaddison

I need the information (that's in the sheet labeled "master file") filled in matching up with the information from the other sheets. In the master file sheet I need the columns to reflect the lowest prices from each sheet (Texas,Florida) and also bring in the location, plus any other info from the other columns past that. Basically, I need the part#'s from the "master file" to match up with the other sheets part #'s and then grab all the columns associated with that part # and pick the lowest price in each column and apply it in the "master file". Am i still confusing?

a little
The lowest price? You need 2 sets of data for each line in master sheet one for the Sales Price and one for the Repair price or I'm missing something?

[slurpee55]

In your lists you have some items that should probably be matches, e.g. 1245dw347yh and 12-45dw347yh. They will not show as matches unless they are entered the same or the "-" are deleted. Or are these supposed to be different items?

[slurpee55]

Originally Posted by aaddison

I need the information (that's in the sheet labeled "master file") filled in matching up with the information from the other sheets. In the master file sheet I need the columns to reflect the lowest prices from each sheet (Texas,Florida) and also bring in the location, plus any other info from the other columns past that. Basically, I need the part#'s from the "master file" to match up with the other sheets part #'s and then grab all the columns associated with that part # and pick the lowest price in each column and apply it in the "master file". Am i still confusing?

The only other problem I am finding is that of the location - in the example sheet, for item ED456q1234, Texas has the lower cost but Florida has the lower sales price. Which (if either) do you want to use for showing the location?

[slurpee55]

Given the above, and also not being sure how to return the data for the location anyway (keep getting errors), here is a partial completion

[slurpee55]

The closest I can think of is
=VLOOKUP(D2,Texas:Florida!D2:F5,3)
but it keeps giving me an error....