Absolute sturctured reference in Excel 2007/2010

0
votes

I'm trying to created an "absolute structered reference" in Excel 2007. Formula example is as follows:

=PRODUCT(VLOOKUP([Pilot Name], Loot, MATCH(Table4[[#Headers],[Arkonor]], Loot[#Headers], 0), FALSE), 1)

Where [Pilot Name] is the first column of the table, [Arkonor] is the second column. What I want to be able to do is have [Pilot Name] remain static while [Arkonor] agrees with the header at the top of the current column as I fill across the table.

Currently, when I fill across the table, I get:

=PRODUCT(VLOOKUP([Arkonor], Loot, MATCH(Table4[[#Headers],[Bistot]], Loot[#Headers], 0), FALSE), 1)

But I would like to have:

=PRODUCT(VLOOKUP([Pilot Name], Loot, MATCH(Table4[[#Headers],[Bistot]], Loot[#Headers], 0), FALSE), 1)
1
excelreference

1 Answers

0
votes

consider your Pilot is in column A1,

you need mark it as $A$1, this makes the field static & will not be changed as the formula is filled across the table.