Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP plus IF
I would like to identify a "Y" when it shows up in a column, and then compare
a value in one cell (A2) with the four values in the row next to the "Y" indicator. Can anyone help with this? The "Y" will move up or down within the column depending on values entered in the worksheet, and I already have this part of the formula completed. The value in cell A2 will change. If A2 is greater than the number in column D, then D is returned. If A2 is greater than the number in column E, but not greater than the number in column D, then E would be returned, etc. V 2003 D E F G N 50 40 30 20 Y 45 35 30 25 N 35 30 25 20 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | 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 |