Hi everyone! Needing some help building a formula - I'm at a complete loss at how to do this!
I'm trying to find the file name base (A17:A21) in each cell in A2:A13 and return the proposal number in B17:B21.
ex: Cell B2 should show "1", cell B8 should return "4"
Thanks so much!
I'm trying to find the file name base (A17:A21) in each cell in A2:A13 and return the proposal number in B17:B21.
ex: Cell B2 should show "1", cell B8 should return "4"
Thanks so much!