View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pam Pam is offline
external usenet poster
 
Posts: 128
Default I want excel to input data in a cell from multiple cell choices

In cell Q11.

I want it to display the number 2, if Cell D11 says ICW, I want it to
display the number 1, if F11 says ICW, I want it to display the number 3, if
L11 says ICW, and finally, I want it to display the number 5, if cell E11
says ASFC.

If none of these apply, I want it to say NA.

I have tried dozens of formulas and I might get the values I want, but I get
a blank instead of NA