Thread: vlookup= or <=?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Rickyzcarroll@gmail.com is offline
external usenet poster
 
Posts: 2
Default vlookup= or <=?

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.