Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks in advance for any assistance!
Worksheet 1 has: Column A = Positions There are 6 levels, ie: P1, P4, T9,... Column G = Expenses, in $. Worksheet 2 has: A table listing the positions (same as Column A in 1st worksheet). Also contains 'Max Spending Level' in $, in Column B. How can I use IF & VLOOKUP nested together to: Have it look at the Position in Column A in worksheet 1, then look at the Expenses in Column G (worksheet 1) and see if those expenses are over the 'Max Spending Level' on the Table in the 2nd worksheet (column B), depending on the Position in Column A in that same table? Or, otherwise stated: I need Worksheet 1 to reference Worksheet 2's table. I need it to return a value of 0 if it is not over the Max Spending Level, but if it is over, then I need it to return that value. If I've been too verbose and not clear, please let me know. I will try anything. Thanks much! - TexJen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
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 | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |