pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
I have a table from where i do a vlookup.
when i try to remove by 0 from appearing when there is no value in table
=IF(ISBLANK(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)),"",(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)))
#n/A appears
and when i use
=IF(ISNA(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)),"",(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)))
when the cell is blank 0 appears...
Is there a formula to avoid getting any of this error/ result and get blank with there is no value in table
Thanks again!
when i try to remove by 0 from appearing when there is no value in table
=IF(ISBLANK(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)),"",(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)))
#n/A appears
and when i use
=IF(ISNA(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)),"",(VLOOKUP($C$3,CompletedTrainingsonly!$A$20:$V$35,2)))
when the cell is blank 0 appears...
Is there a formula to avoid getting any of this error/ result and get blank with there is no value in table
Thanks again!