ExcelBanter - How can I look up text instead of values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I look up text instead of values (https://www.excelbanter.com/excel-worksheet-functions/143472-how-can-i-look-up-text-instead-values.html)

Rookiekookie

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 ?

Mike H

How can I look up text instead of values

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 ?

All times are GMT +1. The time now is 10:39 PM.