Vlookup showing 0

[Chickenkicker99]

Hi i have some blank cells and on my V lookup it shows 0 is there a way I can change the value of the 0 to show text instead

[63falcondude]

Sure, a brute force method is this:

=IF(VLOOKUP(...)=0,"text",VLOOKUP(...))

Assuming that none of the 0's are actually supposed to be there.

[Chickenkicker99]

=VLOOKUP(A2,WFR!B:H,7,FALSE) is my formula where would i put 0="text"

[AliGW]

Here:

=IF(VLOOKUP(A2,WFR!B:H,7,FALSE)=0,"your text here",VLOOKUP(A2,WFR!B:H,7,FALSE))

[63falcondude]

You can try this:

=IF(VLOOKUP(A2,WFR!B:H,7,FALSE)=0,"text",VLOOKUP(A2,WFR!B:H,7,FALSE))

The red font shows your original formula.

[Chickenkicker99]

Sweet thanks guys this website is helping me so much

[63falcondude]

You're welcome. Thanks for the rep!

If that solved your question, please mark this thread as SOLVED.