You may use HLOOKUP, so the formula in I7 can be:
=H7*HLOOKUP($G7,$B$3:$G$4,2)

Hope this helps,
Miguel.

"Glyn" wrote:


Hi folks, its been a long time since Ive used Excel, and Im stuck,
what Id like to do is to have I7 check the pay code in G7 and then
multiply it by H7
I suspect I should be using the LOOKUP function with an absolute
reference?
Any ideas, regards Glyn

[image: http://img432.imageshack.us/img432/2213/excel5va.jpg]


--
Glyn
------------------------------------------------------------------------
Glyn's Profile: http://www.excelforum.com/member.php...o&userid=34678
View this thread: http://www.excelforum.com/showthread...hreadid=544449