| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Typing "true" excel 2007 change it to "TRUE" | Excel Discussion (Misc queries) | |||
| How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Can you replace "TRUE" with " " in an exact formula? | Excel Worksheet Functions | |||
Linear Mode
