Log In
Register
Home
Active Member
June 12, 2020
Offline
Hi there,
could anyone solve this problem (in the attactment)? the formula working well but not consistent result.
Active Member
June 12, 2020
Offline
sorry for double attachment. there are the same file
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Please give more information of what it is you are looking for and what the expected result should be. As it is now I can only guess what is wrong.
Br,
Anders
Active Member
June 12, 2020
Offline
Sorry Anders for my message that are not clear enough,
I have data from bank transaction that have a name in the transaction (column A).
I want to get the name (from column A) which is match to the name list in Column F.
The Result in column C.
with the given formula that I see in Mynda's website, most of the result match to the name list in column F (if it doesn't match than will result #N/A result which is as expected),
but in some cell in column C, the result are not as expected:
- Result in C23: "MER". It should result "MARKOS P" that match to name list in column F (row 46)
- Result in C24 & C26: #REF!. It should result #N/A because there are not in name list (column F)
thank you
Br,
Fendy
July 16, 2010
Offline
Hi Fendy,
The problem is caused because there are multiple matches in your List e.g. item 5, AR is in the value in cell A23 as is item 46, 'MARKOS P' which adds up to 51 (5+46) and so it returns MAR, which is item 51 in the list.
With the values in cells A24 and A26 there are errors because there are multiple matches which add to values greater than 134 (179 and 190 respectively), so it returns a #REF! error because there are only 134 items in the List.
You need to remove the ambiguity from your list so Excel knows which name to match.
Mynda
1 Guest(s)
