Hello,
I am looking to pull values from an assortment of invoice formats that will populate a summary sheet (example below). Though location of "Fund" and "Amount" can vary within each invoice (and they don't always begin on row 1), they always contain the same headers. Is there a way to dynamically pull the correct values without needing to adjust my formula each time I drop in an invoice? What formula in cell B3 would allow for this?
Thanks for any help.
<blockquote class="imgur-embed-pub" lang="en" data-id="Y7D40Eg"><a href="//imgur.com/Y7D40Eg">View post on imgur.com</a></blockquote>******** async src="//s.imgur.com/min/embed.js" charset="utf-8">*********>
