MATCH and VLOOKUP

  • Thread starter Thread starter David French
  • Start date Start date
D

David French

Below are my examples.

The top 3 columns are my budget sheet where I need my dollar (num) amount to
come to.
The lower is my VLOOKUP table array.
I need VLOOKUP to find the Account Number (GL Code) and MATCH the
Profit/Cost Center since we have 8 different cost centers.

I know this can be done it's just that I"m having trouble with my formula.
My TableArray is on 'Sheet1'

=VLOOKUP(A8,Sheet1!$A$1:$C$21,3,MATCH($B8,Sheet1!$A$1:$C$1,1))

Please help!!

Dave French


Account Number Profit/Cost Center DESCRIPTION
1000EXP EXPENSES
1000EMP_EXP EMPLOYEE EXPENSE
1000EMPL_BEN EMPLOYEE BENEFITS
602100 001GE Emp Ben - Gp Health
602300 001GE Emp Ben- Payroll Tax
602400 001GE Emp Ben- Retirement
602500 001GE Emp Ben Workers Comp
602600 001GE Emp Ben- Other


GLCode Pcenter Num
602100 001GE 1
602300 001GE 2
602400 001GE 3
602500 001GE 4
602600 001GE 5
602100 002GE 6
602300 002GE 7
602400 002GE 8
602500 002GE 9
602600 002GE 10
602100 003GE 11
602300 003GE 12
602400 003GE 13
602500 003GE 14
602600 003GE 15
602100 004GE 16
602300 004GE 17
602400 004GE 18
602500 004GE 19
602600 004GE 20
 
Back
Top