Apr 04 2021 04:16 AM
I would like you to help me with the formula that I am looking for I wanna a formula that will allow to me comparing date and value (like products, SKU products model ) with the 7 sheets and get me the matched value and lowest price and sheet name
I have attached a sample of my worksheet
Apr 04 2021 06:16 AM
Solution
First, that is not a "sample of [your] worksheet"-- it's just an image. We'd be better able to hep if you attach an actual copy of the workbook or at the very least a couple of the worksheets. Not images.
Second: some questions for you
Apr 04 2021 06:44 AM
@mathetes thanks for your reply please find the list and the I am working on windows 10
Apr 04 2021 07:39 PM
You are a person of few words.
One of the first problems you're going to need to address is that of getting more consistency between the various lists. My quick review suggests that sheets 1, 2 and 7 provide the most helpful formats. Pick one of those and make it the "standard" and then reorganize the others--to the extent possible--so the columns contain comparable and consistent data.
As it is, I have a hard time figuring out how even Power Query could work--it needs some kind of consistent "key" or "identifier" on each table for each kind of device; right now you don't have that. (For example, look at how Lenovo devices are identified and described on your sheet 1 and your sheet 7. And that does no more than scratch the surface.)
You've heard, I presume, the old computer adage, "GIGO"?
"Garbage in, garbage out."
It's an unkind description, but it basically is saying that if your data is full of glaring inconsistencies, you're not going to be able to work effectively with it.
Apr 04 2021 06:16 AM
Solution
First, that is not a "sample of [your] worksheet"-- it's just an image. We'd be better able to hep if you attach an actual copy of the workbook or at the very least a couple of the worksheets. Not images.
Second: some questions for you