sshrikanth2
Board Regular
- Joined
- Jan 17, 2012
- Messages
- 138
Hi,
I need your help..
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
I need your help..
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