Vlookup works perfectly to find the first part my problem, but what I need is to know if there is any text in the cell to the right.

My current formula is =VLOOKUP(A8,B:E,1,FALSE)

The value of A8 is 20, and the cell 20 appears in is B7. VLOOKUP finds that 20 is in B8 but I need a second part to pull whether text is entered into C7. The formula I use to find if text is
entered usually is =IF((ISBLANK(C7)),"No","Yes".

How can I have vlookup return what cell it finds 20 in, then use ISBLANK to search text? Or a faster way if possible :P