=+Vlookup

[the hotspur amigo]

using the below formula as e example can depend on what appears in that cell depending on what is in B3 but when B3 is empty it shows as "#N/A". is it possible to make that blank or will I just have to put up with it showing #N/A till they put something in cell B3?

=+VLOOKUP(B3,Answers!A75:B76,2,FALSE)

 

[mark.wagner]

wrap all that inside an if statement

if(ISNA(vlookup formula),"",vlookup formula)

 

[the hotspur amigo]

Sorry i have read that and tried but i cant get it to work. can you or some elaborate.

 

[mark.wagner]

=if(isna(VLOOKUP(B3,Answers!A75:B76,2,FALSE)),"",VLOOKUP(B3,Answers!A75:B76,2,FALSE))

 

[Aladin Akyurek]

ADVERTISEMENT

using the below formula as e example can depend on what appears in that cell depending on what is in B3 but when B3 is empty it shows as "#N/A". is it possible to make that blank or will I just have to put up with it showing #N/A till they put something in cell B3?

=+VLOOKUP(B3,Answers!A75:B76,2,FALSE)

=IF(B3<>"",VLOOKUP(B3,Answers!A$75:$B$76,2,0),"")

 

[mark.wagner]

I see what you're doing, aladin; nice solution.

 

[the hotspur amigo]

ADVERTISEMENT

Cheers guys but i have tried both formula and both make the N/A disapear but then when entering Yes or No into B3 nothing comes up. is there something in the formula i should be adding?

 

[just_jon]

Cheers guys but i have tried both formula and both make the N/A disapear but then when entering Yes or No into B3 nothing comes up. is there something in the formula i should be adding?

Do you have calculation enabled?

 

[the hotspur amigo]

i wouldnt know to be honest. how can i look?

 

[just_jon]

Tools | Options Calculation tab

Make sure calculation is checked at automatic.