Forum Discussion

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
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.

Juliano-Petrukio

Bronze Contributor

Oct 29, 2021

Can you please add some file containing the sample data instead just the image?
It will help us to assist you.

Mr_McSquirrelly
Copper Contributor
Oct 29, 2021
Juliano-Petrukio

I would like VLookup only to return data from named range from teams with scores in adjacent cells and to ignore teams with blank cells or no scores in above range.
TESTSHEET.xlsx2.4 MB
- Juliano-Petrukio
  Bronze Contributor
  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.
  - Mr_McSquirrely
    Copper Contributor
    Nov 04, 2021
    Juliano-Petrukio That is the solution I was looking for! I could not find the email I used for my original account, so I started a new account. Many, many thanks Juliano-Petrukio!