Copy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pasty - 25 Oct 2006 10:29 GMT

=VLOOKUP(G284,AG1:AL6,MATCH(H284,AH1:AL1,0)+1,FALSE)

Is there anyway of copying this formula to multiple sheets with only the
cells G284 & H284 increasing by 1 each time - as AG1:AL6 & AH1:AL1 is a
reference to a data table.

Reply to this Message

Roger Govier - 25 Oct 2006 11:22 GMT

Hi

Create 2 named ranges
Insert>Name>Define> Name range1 Refers to Sheet1!AG1:AL6
and Name range2 Refers to Sheet1!AH1:AL1

The change formula to
=VLOOKUP(G284,range1,MATCH(H284,range2,0)+1,FALSE)

Signature

Regards

Roger Govier

> =VLOOKUP(G284,AG1:AL6,MATCH(H284,AH1:AL1,0)+1,FALSE)
>
[quoted text clipped - 3 lines]
> a
> reference to a data table.

Reply to this Message