Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup or index/match formula?? | Excel Worksheet Functions | |||
Help with VLOOKUP & MATCH formula | Excel Worksheet Functions | |||
Match, VLookup possible formula needed | Excel Discussion (Misc queries) | |||
Sum Vlookup / Match Formula across 8 workbooks | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |