Thread: IF Statement or VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HL HL is offline
external usenet poster
  
Posts: 8
Default IF Statement or VLOOKUP
I don't know if I should use an IF statement or VLOOKUP but but i would like
to do the following:
IF A2=0073 THEN B2 = Sales
IF A3 = 0083 THEN B3 = District

Column A will contain information like: 0082, 0092, 0073, etc. Column B is
empty right now but i want to use a formula to insert the ID name based on
the ID listed in column A.

How do i do this?
Reply With QuoteReply With Quote