Is there a best practice formula to use for this scenario?

cvazque6

I'm attempting to grab the value circled below on a daily basis and feed into in a master spreadsheet. I'm using a MAX formula in the latest record to help me capture the relevant record.

It would feed into this spot in my other spreadsheet

My thought is to do a formula to say if latest record is checked, grab value in "Batch 1 FL QC Review Complete (Docs)" row and feed it to my master spreadsheet. I'm just having a hard time with my testing and can't seem to get it right. Any ideas?

Paul Newcome

You would use an INDEX/MATCH.

=INDEX({Range To Pull}, MATCH(true, {Checkbox Range}, 0))

cvazque6

@Paul Newcome you've been extremely helpful before if you have any thoughts?

Paul Newcome

You would use an INDEX/MATCH.

=INDEX({Range To Pull}, MATCH(true, {Checkbox Range}, 0))

cvazque6

@Paul Newcome that worked. Thank you so much!

Paul Newcome

Happy to help. 👍️