| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - copy absolute cell references (within the range) as relati | Excel Discussion (Misc queries) | |||
| Copy Tab function not working | Excel Discussion (Misc queries) | |||
| copy with format | New Users to Excel | |||
| Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
| Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Linear Mode
