Nested VLOOKUP?
P.S.
You should immediately change your gmail password! You don't want everyone
that reads these forums to have access to your account.
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
Its like if I created a uniqueID for each row and
did a vlookup on it right?
Essentially, yes!
Here's the formula based on your file link:
=SUMPRODUCT(--(D24:D47=ShipWeight),--(E24:E47=ShipWidth),--(F24:F47=ShipLength),--(G24:G47=ShipHeight),H24:H47)
--
Biff
Microsoft Excel MVP
"Antoine" wrote in message
...
Hi!
Thank you for your help.
I think I understand your workaround.
Its like if I created a uniqueID for each row and did a vlookup on it
right?
Thank you.
Antoine
|