Thread: How do I?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondo Bondo is offline
external usenet poster
 
Posts: 2
Default How do I?

If cell B1 = 1001, I would like cell A1 to reflect "A".
If cell B2 = 1002, then cell A2 should be "B" and so on.
And if cell B1 = 1003, then cell A1 should be "C".
I need column A to read A,B or C based on column B being a value of 1001-1003.
Make sense?

TIA
Bill Bondo