Forum Discussion

Copper Contributor

Nov 02, 2020

Solved

Combining data in a new table

I have a table with products, prices and then quantity by customer - I would like to create a new table with the total price of the products by customer. I know I can create a million vlookups of the...

Formulas and Functions

NikolinoDE
Nov 02, 2020
Although I think Power Query is more appropriate here. Add a MS Excel file (without sensitive data) to your project. Knowing the Excel version also be an advantage. So you could get a much more concrete solution than the one I sent. Thank you for your understanding and patience Nikolino I know I don't know anything (Socrates)

NikolinoDE

Platinum Contributor

Nov 02, 2020

mariong

A noble offer from Mr.Sergei Baklan

can only recommend it :)))

https://techcommunity.microsoft.com/t5/excel/look-up-in-table-based-on-4-values/m-p/1839794#M79568

To continue tinkering yourself 🙂

XLOOKUP(
  D14,
  ($A$2:$A$9&$B$2:$B$9&$C$2:$C$9=A14&B14&C14)*$D$2:$D$9,
  $F$2:$F$9,
  "no such",
   -1

Hope it helped you

Nikolino

I know I don't know anything (Socrates)