Thread
:
Copy
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Pasty
external usenet poster
Posts: 95
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.
Reply With Quote
Pasty
View Public Profile
Find all posts by Pasty