Incorrect VLOOKUP expression

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

Can someone tell me what I'm doing wrong with this formula?

=VLOOKUP(A2, [activebillings2004.xls]Actuals, MATCH(B1,
[activebillings2004.xls]Months,0)+1,FALSE)

I want it to look up the defined name table on another worksheet to get the
value that matches the customer name in a2 and the month in b1. I keep
getting a #NAME? error.

What am I doing wrong?
 
Hi
try
=VLOOKUP(A2, activebillings2004!Actuals,
MATCH(B1,activebillings2004!Months,0)+1,FALSE)
 
Back
Top