Forum Discussion

Copper Contributor

Aug 23, 2017

VLOOKUP help required

I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the ...

Formulas & Functions

Need Help

vihargadhesariya

Iron Contributor

Jun 11, 2025

Try SUMPRODUCT

= D4 * SUMPRODUCT(
   (Table3[Category]=$H$4) *
   (Table3[ProjectElement]=$C4) *
   (Table3[weighting])
)

Or INDEX/MATCH:

= D4 *
  INDEX(
    Table3[weighting],
    MATCH(
      1,
      INDEX(
        (Table3[Category]=$H$4) *
        (Table3[ProjectElement]=$C4),
      0),
    0)
  )