Is there a best practice formula to use for this scenario?
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?
Best Answer
-
You would use an INDEX/MATCH.
=INDEX({Range To Pull}, MATCH(true, {Checkbox Range}, 0))
Answers
-
@Paul Newcome you've been extremely helpful before if you have any thoughts?
-
You would use an INDEX/MATCH.
=INDEX({Range To Pull}, MATCH(true, {Checkbox Range}, 0))
-
@Paul Newcome that worked. Thank you so much!
Help Article Resources
Categories
Check out the Formula Handbook template!