Create Dynamic Range for a vLookup

[BrittKnee]

Hey there. I was wondering what the formula would be to create a dynamic range for a vlookup. The columns will remain constant, however the number of accounts will vary depending on the client.

Thanks.

 

[Joe4]

Perhaps this will help.

In the second argument of the VLOOKUP, you can use whole column references (like "C:E") or named ranges (see: https://www.myexcelonline.com/blog/excel-named-ranges-with-vlookup-formula-excel/).
If that does help, then I am not sure we are clear on what you are asking. It might be best to walk us through an example of what you are talking about.