I am trying to work with an excel table that I pull into excel from Access.
On the exclosed worksheet I want to type in the two values in yellow on the Offer tab and lookup the corresponding numbers in the data tab which contains the table. (the number of rows may change in the table each time I import). I do not know what is the most efficient way to do this and be able to replicate the lookup down an entire column.
I asked this previously and got great help but I now figured out enough that I think a table in excel may be faster. Any guidance on all of this is appreciated. TableLookup.xlsx