i have a simple vlookup formula that works eg
=VLOOKUP(C11,C108:D158,2,)
but when there is nothin in c11 i get a nasty #n/a appear
so i created this formula
=IF(C3=0,??????,VLOOKUP(C3,C101:D151,2,))
what can i put in the ?????? to have a blank cell
Bookmarks