# Challenges in Vlookup function

#### sshrikanth2

##### Board Regular
Hi,

I have used a vlookup formula as below. And when there is match not found it shows blank ("") instead of #N/A, but when there is match found and no value in another column then it shows zero. But, i want it to show blank as well when there is a value not found in the another column. I appreciate your assistance.

=IF(ISNA(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)),"",(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)))

Regards,

Srikanth M

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Jonmo1

##### MrExcel MVP
You have to check the result of the vlookup for ""

=IF(ISNA(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)),"",IF(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)="","",VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)))

Or if the expected return of the vlookup is TEXT and not number, you can use the t function.
=IF(ISNA(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)),"",T(VLOOKUP(C7,'Vasu'!\$A\$2:\$V\$18306,2,0)))

#### Dryver14

##### Well-known Member
Jonmo,

What is that T for?

#### Jonmo1

##### MrExcel MVP
Jonmo,

What is that T for?

Here's it's description in the formula wizard dialogue
"Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not."

#### Dryver14

##### Well-known Member
Thanks,

I will look at that later.

Replies
19
Views
297
Replies
0
Views
103
Replies
7
Views
611
Replies
5
Views
163
Replies
1
Views
173

1,195,967
Messages
6,012,600
Members
441,715
Latest member
TTP

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back