Lookup account numbers

C

CAM

Hello,

I have a worksheet called "ChartOfAccounts", which contains chart of
accounts - account number and description. I have another worksheet called
"MonthlyExpense" containing expenses for the month. What I want is to do a
lookup matching the worksheet "MonthlyExpense" with "ChartOAccounts.
Example: In the "MonthlyExpense" worksheet there is an account number
"AT2543050509" I want to match with the corresponding account number from
the "ChartOfAccount" worksheet called "Dues and subscription" account
number "ATXX43050509" the XX in the "ChartOfAccounts" is for the department
number, which varies. I want to somehow match "AT2543050509" from the
"MonthlyExpense" worksheet with "ATXX43050509" from the "ChartOfAccount"
worksheet. How do I do that? My problem is that the 3rd and 4th digit in
the "ChartOfAccounts" contains the "XX". Any tips will be appreciated. I
am using Excel 2007. Thank you in advance.

Cheers
 
J

Joel

You casn use the match function with ? being any character or number. You
need to use the type 0 (last parameter) for it to work

=MATCH("AT??43050509",A1:A100,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using lookup 1
Matching account numbers 1
Optional argument as Variant not acting like number 4
Macro to copy rows into worksheets 4
Conclude new account number 2
LOOKUP function help 2
Compare two worksheets in the same workbook and highlight difference 7
Combine two spreadsheets into one 3

Top