View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ms.maryw ms.maryw is offline
external usenet poster
 
Posts: 3
Default Formula Using Vlookup & Match

I have two worksheets, I am trying to match the value in two cells to
two values on the next sheet. I only need to know if it is a match.

I tried:
=VLOOKUP(A3,B!$A$2:$L$43019,MATCH(B3,B!$A$2:$L$430 19,0),FALSE)

This returns #N/A
A3 has an account number & B3 has a dollar amount. If the account
number matches the dollar amount on the second worksheet (B), I need
to know it's a match.

The account number could appear multiple times for different dollar
amounts.

Thank you