lookup?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glyn - 22 May 2006 21:20 GMT

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]

Signature

Glyn

Reply to this Message

Miguel Zapico - 22 May 2006 21:40 GMT

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

Hope this helps,
Miguel.

> 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
[quoted text clipped - 4 lines]
>
> [image: http://img432.imageshack.us/img432/2213/excel5va.jpg]

Reply to this Message

Biff - 22 May 2006 21:47 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> [image: http://img432.imageshack.us/img432/2213/excel5va.jpg]

Reply to this Message

Glyn - 22 May 2006 22:31 GMT

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

Reply to this Message