Ignore Row with Text Using VLOOKUP

Derharm1 

To skip the cells with PTS, you can use the IF function to check if the cell contains text. If it does, you can return an empty string. Otherwise, you can return the value of the cell.

Here is an example of how to use the IF function to skip the cells with PTS:

=IF(ISTEXT(cell), "", VLOOKUP(cell, lookup_table, col_index_num, range_lookup))

In this formula, the cell parameter is the cell that you want to check. The lookup_table parameter is the table that you want to search. The col_index_num parameter is the column number in the lookup table that contains the value that you want to find. The range_lookup parameter is a logical value that determines whether to search for an exact match or an approximate match.

Here is an example of how to use the formula to count the number of times that a player has been over or under a value in the last 3 games:

=SUMIF(A5:A27, E2, IF(ISTEXT(A5:A27), "", VLOOKUP(A5:A27, Points, 2, FALSE))) + SUMIF(A5:A27, H2, IF(ISTEXT(A5:A27), "", VLOOKUP(A5:A27, Points, 2, FALSE)))

In this formula, the A5:A27 range contains the last 3 games. The E2 and H2 cells contain the vegas line for the specific stat of the player. The Points sheet contains the previous 15 games of data.

This formula will count the number of times that the player has gone over or under the vegas line in the last 3 games. If a cell in the A5:A27 range contains text, then the formula will ignore that cell and count an additional cell. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.