Forum Discussion
VLookup to ignore values with blank cells
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.
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.
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 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!
- Very good to hear that.
If it worked fine, flag it as solved.Juliano-Petrukio Here is the solution to the problem I was looking for. Thanks again!
