Thread: Vlookup, replace true text result with "X"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maxine Maxine is offline
external usenet poster
  
Posts: 16
Default 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!!!!!!!!
Reply With QuoteReply With Quote