I generate a worksheet from my accounting software and do a copy and paste to
insert it into an existing worksheet that contains named ranges. The
spreadsheet also contains period to date and year to date worksheets that are
updated according to main account and sub-account numbers on the sheet I
import. My problem is that new accounts are added every month so my named
ranges keep changing. Right now I'm updating it manually but there are over
3000 lines in the worksheet where the ranges change by 1 or 2 cells.
My question is, does anyone know how I can do a lookup within my existing
formula that would look up the account number in column a and sub-account
number in column b and return the value of column 9 in that row? This is the
current formula where $A149 is the main account number and AUB is my current
named range.
=IF(ISNA(VLOOKUP($A149,AUB,9,FALSE)=7),0,VLOOKUP($ A149,AUB,9,FALSE))
I'm using Excel 2002

Any help would be appreciated!

Thanks
Jayne