Row lookup

[aish28warya]

Hi all,

 Below is an example of data I've.

This is for January month

			January	January	February	February	March	March	so on…
Posting year/date	SAP LE	SAP Centre	Cash	Intra MIS	Cash	Intra MIS	Cash	Intra MIS
1/1/2021	3305	162745	(90)	60	0	0	0	0
1/1/2021	3305	256347	100	0	0	0	0	0
1/1/2021	3305	208430	20	(45)	0	0	0	0

And this is for February month

			January	January	February	February	March	March	so on…
Posting year/date	SAP LE	SAP Centre	Cash	Intra MIS	Cash	Intra MIS	Cash	Intra MIS
2/1/2021	3305	162745	(90)	60	600	10	0	0
2/1/2021	3305	256347	100	0	0	(500)	0	0
2/1/2021	3305	208430	20	(45)	70	(80)	0	0

While uploading February data, I want to do row lookup, where if posting year/date matched with February in the row, then return February Cash & February Intra MIS column. Same for other months.

[afv2688 · Accepted solution]

Hello @aish28warya ,

Would this work for you?

Regards

[OllieClarke · Accepted solution]

Hi @aish28warya here's how I'd go about this:

Hope that helps,

Ollie

[aish28warya]

Hey, thank you for the response. This one works for me.