So I have an issue...Hopefully someone here is literate enough in Excel to help me. I am using this function to reference items in a table. The problem is the lookup value A9 changes, and I need the table array to change with it. So this is the function: Assume Cell A9 says Service, then this will work. =VLOOKUP($A9,Service_Array,3,FALSE) However if Cell A9 says Lease I need the function to dynamically change to say this: =VLOOKUP($A9,Lease_Array,3,FALSE) Somehow I need to reference A9 to change the table array option in this function.