Multi variable lookup / reverse hlookup

[kneebone]

Hi There,

I'm trying to get data ready to move from Excel into a database & I have thousands of rows/columns like the following. For each unique RequestID, I need to return the Year the transaction occurred. Appreciate any guidance!

 

[kneebone]

Nvm...I figured it out. =INDEX($C$2:$G$2,,MATCH(MAX(C3:G3),C3:G3,0))

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

A couple of other ways too ..

22 09 22.xlsm
	A	B	C	D	E	F	G
1
2			2018	2019	2020	2021	2022
3		A	3
4		B		5
5		C				9
6
7
8		A	2018	2018
9		B	2019	2019
10		C	2021	2021
Get Heading

Cell Formulas
Range	Formula
C8:C10	C8	=FILTER(C$2:G$2,C3:G3<>"")
D8:D10	D8	=LOOKUP(9^9,C3:G3,C$2:G$2)

 

[nageswararao]

Enter the following array formula at C17 i..e. press ctrl+shift+enter and copy down up to cell C26.

=INDEX(3:3,MAX(COLUMN(3:3)*(3:3<>"")))

 

[Peter_SSs]

@nageswararao
The OP is trying to return the year for each transaction.

I need to return the Year the transaction occurred

 

[nageswararao]

Yes.