Hi all,
I managed to get this array formula to work, which returns the value in column F (Lookup! table) based on two criteria (D3 and D4) on my main worksheet.
The reason why I am using this formula (and not lookup, sumproduct or else) is because I am trying to lookup multiple values in a table based on the same criteria (see as an example here: "Formula 3. Vlookup multiple matches based on multiple conditions")Please Login or Register to view this content.
Now I am trying to add in another lookup criteria for D5 which should lookup the value in Lookup!C2:C500 and return the same result as the formula above (basically just checking for a 3rd criteria). I've tried this, but it gives me a #Num error :-(
Do you guys have an idea why or what I am doing wrong?Please Login or Register to view this content.
Many thanks for your help!
Bookmarks