lookup?

[Glyn]

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]

 

[Miguel Zapico]

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

Hope this helps,
Miguel.

 

[Biff]

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]

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