Forum Discussion

Mr_McSquirrelly's avatar
Mr_McSquirrelly
Copper Contributor
Oct 29, 2021
Solved

VLookup to ignore values with blank cells

Is it possible to make Vlookup ignore lookup values with adjacent blank cells? Here's the problem:     VLookup returns data from a named range to the bottom list of teams. But I only need th...
excel
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Oct 30, 2021

    Mr_McSquirrelly 

    Considering you are on cell B94 (Charlotte Hornets)

    Try instead ISBLANK() formula confirm like below.

     

     

    =IF(B2="","",VLOOKUP(A94,TEAMPOWER_AVGSEASON,2,FALSE))

     

     

    Ps.: As I'm not sure about the data of the named range TEAMPOWER_AVGSEASON, I considered the 2nd column as the OFF values.

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Oct 29, 2021

Mr_McSquirrelly 

I haven't touched VLOOKUP for years but turning the team names without an associated score to FALSE would prevent the lookup returning data for it, e.g.

= VLOOKUP(lookupVal, IF(ISNUMBER(scores),table), 2, 0)

Resources