Vlookup, replace true text result with "X"

[Maxine]

I have a formula that requires and "X" to replace the true result in a cell.
The source of the data is located in a vlookup. How do I replace a "yes"
result with an "x" results. I also need to return a blank result if the
vlookup is false.
This is the formula I have:
=IF(D21="","",IF(G21="xxxxxxxxxxxx","",VLOOKUP(D21,inventory!A212,4)))

Please Help!!!!!!!!

 

[Marcelo]

=if(iserror(vlookup(c2,a2:b100,2,0))," ",rept("X",15))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Maxine" escreveu:

 

[Maxine]

I apologize. I do not believe I was very clear in my description of my
problem. The formula I need requires a few variables. The formula needs to
address a blank result if the relative cell is blank. It also needs to place
"xxxxxxx" if the an invalid number is entered in the relative cell. And
lastly, if the vlookup finds an exact match, which would be the text "yes",
then it needs to return a result of "X" instead of the text "yes".

I apologize for the confusion.

 

[Marcelo]

ok, lets try

=IF(A5="","",IF(ISERROR(VLOOKUP(A5,D5:E12,2,0)),REPT("X",12),VLOOKUP(A5,D5:E12,2,0)))

Hope this help
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Maxine" escreveu:

 

[Marcelo]

my apologies, please adjusting the range as you need

=IF(D21="","",IF(ISERROR(VLOOKUP(D21,inventory!A212,4)),REPT("X",12),VLOOKUP(D21,inventory!A212,4)))

Sorry for that


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

 

[Maxine]

Thanks for the help!!!! I appreciate it!

my apologies, please adjusting the range as you need

=IF(D21="","",IF(ISERROR(VLOOKUP(D21,inventory!A212,4)),REPT("X",12),VLOOKUP(D21,inventory!A212,4)))

Sorry for that


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu: