Thread: Nested VLOOKUP?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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