View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kath Kath is offline
external usenet poster
 
Posts: 23
Default I need to return one of three answers in a cell

I need to have one of three results show up in the cell.

I am using VLOOKUP to get my data result, but I need the cell to display
"unknown" if the requested data is not valid. However to add to that, I need
the cell to display nothing at all if there is no data being requested.

Does anyone have any suggestions please?