Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hi all
I have a vlookup table shown here 3.0% £375.00 4.0% £250.00 5.0% £120.00 6.0% £90.00 7.0% £60.00 My calculation is =VLOOKUP('Diagnostics technician'!G12,'Diagnostics technician'!O8:P12,2,TRUE)+VLOOKUP('Diagnostics technician'!E12,'Diagnostics technician'!J7:K13,2,TRUE) Unfortunately i need the cell to display £120 if the percentage is over 4%, the percentage at the moment is 4.03% and is displaying £250 I hope that makes sense, can anyone help? Thank you all in advance Derek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |