Vlookup, replace true text result with "X"
 

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!A2:D12,4)))

Please Help!!!!!!!!

Vlookup, replace true text result with "X"
 

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

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



"Maxine" escreveu:

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!A2:D12,4)))

Please Help!!!!!!!!

Vlookup, replace true text result with "X"
 

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" wrote:

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

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



"Maxine" escreveu:

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!A2:D12,4)))

Please Help!!!!!!!!

Vlookup, replace true text result with "X"
 

ok, lets try

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

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



"Maxine" escreveu:

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" wrote:

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

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



"Maxine" escreveu:

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!A2:D12,4)))

Please Help!!!!!!!!

Vlookup, replace true text result with "X"
 

my apologies, please adjusting the range as you need

=IF(D21="","",IF(ISERROR(VLOOKUP(D21,inventory!A2: D12,4)),REPT("X",12),VLOOKUP(D21,inventory!A2:D12, 4)))

Sorry for that


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



"Marcelo" escreveu:

ok, lets try

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

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



"Maxine" escreveu:

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" wrote:

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

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



"Maxine" escreveu:

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!A2:D12,4)))

Please Help!!!!!!!!

Vlookup, replace true text result with "X"
 

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

"Marcelo" wrote:

my apologies, please adjusting the range as you need

=IF(D21="","",IF(ISERROR(VLOOKUP(D21,inventory!A2: D12,4)),REPT("X",12),VLOOKUP(D21,inventory!A2:D12, 4)))

Sorry for that


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



"Marcelo" escreveu:

ok, lets try

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

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



"Maxine" escreveu:

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" wrote:

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

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



"Maxine" escreveu:

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!A2:D12,4)))

Please Help!!!!!!!!