Large formula with absolute reference

[chris999]

Hi all,

I have a match formula linked to a drop-down list.. So that the user selects the variable, and the match formula says the data is in column 4.

I want to use the Large formula to pull the biggest, 2nd biggest, 3rd biggest, etc.. from the data in column 4..

Currently I have
=LARGE(SameDay!D$2:D$400,1)

where "SameDay" is the sheet that contains the data. Suppose the column # I want to search is in cell C1.. If C1 changes to 6 for example, how would the formula be written so that it would search the F column, instead of the D column..?

 

[Jonmo1]

Welcome to the board...

Try

=LARGE(INDEX(SameDay!A$2:Z$400,0,$C$1),1)


Hope that helps.

 

[chris999]

Thank you, it works! Very neat..