ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy (https://www.excelbanter.com/excel-worksheet-functions/115981-copy.html)

Pasty

Copy

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

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.

Roger Govier

Copy

Hi

Create 2 named ranges
InsertNameDefine 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)

--
Regards

Roger Govier

"Pasty" wrote in message
...
=VLOOKUP(G284,AG1:AL6,MATCH(H284,AH1:AL1,0)+1,FALS E)

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.

All times are GMT +1. The time now is 03:41 PM.