Lookup help using INDIRECT

[Kuehl5000]

Help me with the example workbook. The formulas in Scorecard!B3:C5 do what I want them to do but are cumbersome when the lookup rows change. I want to reference the lookup rows.

I want to go from this (Scorecard!B3): =INDIRECT($A$17&B$19&$B20)

To something like this (Scorecard!D3): =INDIRECT($A$17&D$19&"$F"&F3)


How can this be done?

Thanks,
Jim

[Ace_XL]

You can do away with the INDIRECT function and the lookup area from Row 15 onwards.

In B3 of 'Scorecard' tab use

Please Login or Register  to view this content.

Copy down and across. This should give you desired results

[Kuehl5000]

This is why I love this forum.

Thanks Ace!!