Lookup Table Question
I'm trying to figure out a way to apply my vlookup or index/match combo as a dynamic formula across my sheet. I have a set cell that I can use as the beginning of my array of cells to reference but I want the formula to update the final cell based upon the row I'm at minus 1.
There may be a much better way of handling this but I'm not finding it and would love feedback on more intelligent builds if anyone has an idea.
Formula in test is:
=VLOOKUP([Parent UID]3, [Parent UID]3:[Column3]@row-1, 2, false)
Thanks a ton!
Help Article Resources
Check out the Formula Handbook template!