Forum Discussion
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...
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 figured it out:
you can use the formula in the image using filter but not be able to use the named range or you can use:
=VLOOKUP(A96,TEAMPOWER_AVGSEASON,6,0)
=VLOOKUP(A96,TEAMPOWER_AVGSEASON,7,0)
=VLOOKUP(D96,TEAMPOWER_AVGSEASON,8,0)
=VLOOKUP(D96,TEAMPOWER_AVGSEASON,9,0)
respectively in that order from left to right see image below:
File attached below
Yea_So Thank you for your work on this, Yea_So. You have been incredibly helpful. Juliano-Petrukio solved the problem and just made my sheet work perfectly.