Vlookup
Hi Mike
Thanks for the reply, tried it and adjusted the cells to match the
'Diagnostics technician' but it didnt work unfortunately
:(
"Mike H" wrote:
Hi,
Try this
=INDEX(P8:P12,IF(ISNUMBER(MATCH(G12,O8:O12,0)),MAT CH(G12,O8:O12,0),1+MATCH(G12,O8:O12,1)))+INDEX(K7: K13,IF(ISNUMBER(MATCH(E12,J7:J13,0)),MATCH(E12,J7: J13,0),1+MATCH(E12,J7:J13,1)))
Mike
"Derek M" wrote:
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
|