Can I parameterize vlookup?

**hcohen** · 11-25-2021, 05:13 AM

I have a table that is the target of vlookup that will change over time. Specifically, I expect it to grow.
What I would like is to refer to the table in a way that would take growth into account without having to edit all of the many places where vlookup is called.

Can dynamic arrays help with this?
I can guarantee that any additions will occur at the end of the pre-existing table and that there will be no blank rows.
It would also be convenient if I could refer to the whole table by name rather than with a range.

Many thanks,
Hank C.

**JohnTopley** · 11-25-2021, 05:23 AM

Use structured tables which "dynamically" re-size as columns/rows are added/deleted.

Existing VLOOKUPs should not require change if columns are appended to the table.

**hcohen** · 11-25-2021, 08:17 AM

Thanks.
Now I just need to find the tutorial on structured tables.

Hank

**JohnTopley** · 11-25-2021, 09:20 AM

A simple example as attached Tables not my forte!):

Enter data in A1:D8

Highlight this range ..Insert>>Table

Add in E1: Tax Paid

in e2: "=" (as per formula entry) >> click on C2 then "*" click on D2

You will see formula is reproduced automatically until last row of table

Add entry in row 9

change VLOOKUP parameter in F3 to that of value in A9