| 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. |
| 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) | |||
Threaded Mode
