software

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: img432.imageshack.us/img432/2213/excel5va.jpg]--
Glyn
------------------------------------------------------------------------
Glyn's Profile: www.excelforum.com/member.php...oamp;userid=34678
View this thread: www.excelforum.com/showthread...hreadid=544449You may use HLOOKUP, so the formula in I7 can be:
=H7*HLOOKUP($G7,$B$3:$G$4,2)

Hope this helps,
Miguel.

quot;Glynquot; wrote:

gt;
gt; Hi folks, it’s been a long time since I’ve used Excel, and I’m stuck,
gt; what I’d like to do is to have I7 check the pay code in G7 and then
gt; multiply it by H7
gt; I suspect I should be using the LOOKUP function with an absolute
gt; reference?
gt; Any ideas, regards Glyn
gt;
gt; [image: img432.imageshack.us/img432/2213/excel5va.jpg]
gt;
gt;
gt; --
gt; Glyn
gt; ------------------------------------------------------------------------
gt; Glyn's Profile: www.excelforum.com/member.php...oamp;userid=34678
gt; View this thread: www.excelforum.com/showthread...hreadid=544449
gt;
gt;

Hi!

Try this in I7 then copy down as needed:

=IF(COUNTA(G7:H7)lt;2,quot;quot;,H7*INDEX(B$4:G$4,MATCH(G7,B $3:G$3,0)))

Biff

quot;Glynquot; gt; wrote in message
...
gt;
gt; Hi folks, it's been a long time since I've used Excel, and I'm stuck,
gt; what I'd like to do is to have I7 check the pay code in G7 and then
gt; multiply it by H7
gt; I suspect I should be using the LOOKUP function with an absolute
gt; reference?
gt; Any ideas, regards Glyn
gt;
gt; [image: img432.imageshack.us/img432/2213/excel5va.jpg]
gt;
gt;
gt; --
gt; Glyn
gt; ------------------------------------------------------------------------
gt; Glyn's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34678
gt; View this thread: www.excelforum.com/showthread...hreadid=544449
gt;

Thanks Biff amp; 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: www.excelforum.com/member.php...oamp;userid=34678
View this thread: www.excelforum.com/showthread...hreadid=544449