Thread: How can I look up text instead of values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rookiekookie Rookiekookie is offline
external usenet poster
  
Posts: 1
Default How can I look up text instead of values
Monday 1 red
Tuesday 2 orange
Wednesday3 green
Thursday 4 black
Friday 5 white

Hi there, I know how to use VLOOKUP to report on values, but I need to be
able to report on text. In the above example, I need to be able to look at
"Wednesday" to report back the word "green"

Can you please help ?
Reply With QuoteReply With Quote