vlookup returning what cells

[ajwpurevisibility]

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

[davesexcel]

C7 or C8?
If unclear then please attach a simple example,
under normal curcumstances
=VLOOKUP(A8,B:E,2,FALSE)
would supply the result next to the found value, as 2 is the second column in the lookup range.

[ajwpurevisibility]

That formula worked, but it returns #N/A when it doesn't find a vlookup match, and a 0 when there is no data next to a match. Is there a way it can just output a blank cell? (This way I can use Isblank.