Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |