Forum Discussion

A819A1L's avatar
A819A1L
Brass Contributor
Jan 31, 2020

VLOOKUP with multiple criteria (trying to work around SPILL error)

Hi. I really need help with the SPILL error. I know it's been an issue since the update last year and the solution is to select a specified range rather than an entire column, but the result only par...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 31, 2020

A819A1L

 

Hi,

 

Try this formula instead:

=IF(OR(A2=G:G),VLOOKUP(B2,H:J,3,0),0)

 

Or this one below which is faster:

=IF(MATCH(A2,G:G,0),VLOOKUP(B2,H:J,3,0))

 

Hope that helps

  • A819A1L's avatar
    A819A1L
    Brass Contributor
    Jan 31, 2020

    Haytham Amairah Yes, the second one works! Thank You!

     

    Any ideas on how to concatenate the names together?

     

    Abi

      • A819A1L's avatar
        A819A1L
        Brass Contributor
        Jan 31, 2020

        SergeiBaklan 

         

        Thanks.  This formula works best.

Resources