Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using lookup
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |