No VBA: Return Value From One Column Based On The First Occurrence Of A Date In Date Column

[DaddyO]

Using structured references if possible, I need to:

1. Find the first occurrence of a particular Date in a Date column.
2. Return the value in the GmID column from that Row.

Thanks for any help!

Here's the test spreadsheet:

https://1drv.ms/x/s!ArIAG4a3p8D7h5ckByrx6pojIkaiVg

 

[Yongle]

Try this

value to match is in D2

=INDEX('TestSheet'!A:A,MATCH('OtherSheet'!D2,'TestSheet'!B:B,0))

or with everything in the same sheet

=INDEX(A:A,MATCH(D2,B:B,0))

 

[DaddyO]

Thank you, that worked.

 

[Peter_SSs]

Using structured references if possible,...

With the date of interest in D1, try

=INDEX(Table21[GmID],MATCH(D1,Table21[Date],0))

 

[DaddyO]

Thank you Peter for the structured reference solution.

 

[Peter_SSs]

Thank you Peter for the structured reference solution.

You're welcome.