Try,

=VLOOKUP(D1,A1:C6,3,FALSE)

Lookup value in D1 and return colour from column 3.

Mike

"Rookiekookie" wrote:

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 ?