I have the following:

Sheet 1 = Column A = account number (ex. 675000) = lookup_value

Sheet 2 = Column A-G subtotaled for Colunm A, by account = Table_array

Col_index # is for G (7)

My problem, sheet 1 column A is only the account #.

How can I have it find in sheet 2 the account subtotals?

Its something to do with my sheet 1 account number since it doesnt match
the table array €œaccount # total€� on sheet 2 for the lookup.

Thanks