Hello,

I would like to do a Vlookup and return the entire row where the value is located.
I also would like the Vlookup to be dynamic; so if this value is added to another row my Vlookup table will be updated.

I am also open to trying a different method such as Filter, if that would be better.

Any help is greatly appreciated!

Thank you!