lookup?
 

Hi folks, it’s been a long time since I’ve used Excel, and I’m stuck,
what I’d 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

lookup?
 

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

lookup?
 

Hi!

Try this in I7 then copy down as needed:

=IF(COUNTA(G7:H7)<2,"",H7*INDEX(B$4:G$4,MATCH(G7,B $3:G$3,0)))

Biff

"Glyn" wrote in message
...

Hi folks, it's been a long time since I've used Excel, and I'm stuck,
what I'd 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

lookup?
 

Thanks Biff & Miguel, I know it’s probably second nature to you but I
find that bloody amazing, thank you so much
Kindest regards Glyn


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