=VLOOKUP(D1,{0,"Poor";1,"Average";2,"OK";3,"Good"; 4,"Excellent"},2,TRUE)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
Is it possible to use vlookup for = or <=?

Bascially I need to analyze a cell and compare it to a table, and then
select the value if the requirements are met. For example, lets say
the chart has values of Excellent=4, and Good=3. I have an average
column of 3.5. I want to compare the active cell to the average column
and if =, select the excellent rating. Like if the cell was 3.8 i
want it to go through and look until it found a match(the first one)
until it found the match, then select the rating for the active cell.
Is this possible? I could work backwards and <=, until it finds a
match. Let me know what you guys think.