Dear all,
I would like to get your help!
I have an Excel file in which Sheet1 consists of multiple cells.
My lookup_value is C4. C4 is a value that is calculated with the following formula
=LARGE(04:T4,1
where
04 - T4 are the five largest values of named Range and
Range= (=Sheet2!$N$2:$N$100,Sheet2!$AA$2:$AA$100,Sheet2!$AN$2:$AN$100,Sheet2!$BA$2:$BA$100,Sheet2!$BN$2:$BN$100,Sheet2!$CA$2:$CA$100)
I use this as my lookup_array
Now I would like to use a formula to retrieve the cell that is 11 columns to the left of the cell in my lookup_array that is equal to C4. So, this cell could in column C/P/AC/AP/BC or BP in Sheet2
Am I doing the right thing by using the defined Range?
Thank you for your help!!
I would like to get your help!
I have an Excel file in which Sheet1 consists of multiple cells.
My lookup_value is C4. C4 is a value that is calculated with the following formula
=LARGE(04:T4,1
where
04 - T4 are the five largest values of named Range and
Range= (=Sheet2!$N$2:$N$100,Sheet2!$AA$2:$AA$100,Sheet2!$AN$2:$AN$100,Sheet2!$BA$2:$BA$100,Sheet2!$BN$2:$BN$100,Sheet2!$CA$2:$CA$100)
I use this as my lookup_array
Now I would like to use a formula to retrieve the cell that is 11 columns to the left of the cell in my lookup_array that is equal to C4. So, this cell could in column C/P/AC/AP/BC or BP in Sheet2
Am I doing the right thing by using the defined Range?
Thank you for your help!!
Last edited:
