Match Formula Issue
Hi:
In the attached I am trying to fill out the "Order" number in Column C. I need to match up the material based on the Material and Delivery Date matching. I have duplicate materials numbers, so I need to have an exact match where the material and date match to give me the "Order" number.
Column I, J, and K are my data fields I need to search against. I need to pull the correct order number into Column C from Column K based on matching information.
Thanks.
Last edited by johnsor1; 05-03-2013 at 07:44 AM.
Column C has quantities numbers.....in the attached I am trying to fill out the "Order" number in Column C.
Can you pls, tell us the expected results explaining why?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I can't understand your attached file. Can you explain more? I can't find "material", "Delivery Date" in your workbook.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Hi:
Can you take a look at the attached now. I put the wrong file in my original post.
Hi:
In the attached I am trying to fill out the "Order" number in Column C. I need to match up the material based on the Material and Delivery Date matching. I have duplicate materials numbers, so I need to have an exact match where the material and date match to give me the "Order" number.
Column I, J, and K are my data fields I need to search against. I need to pull the correct order number into Column C from Column K based on matching information.
Thanks.
Is your real data like your sample??
What i mean is your dates are mixed..Some are real dates and some are TEXT that looks like date. Same for the Materials Numbers...
Yes, my data is like my sample.. how do I fix this issue?Originally Posted by Fotis1991
Hello,
See if the attached file is what you are looking for.
Note 1: formula used is Array formula, so you will need to hold Ctrl-Shift and hit Enter to confirm. If the formula is being wrapped inside a { } like in the sample then you did it right.
Note 2: your Material number is stored as text, and some of them have trailing space.
Note 3: the date on your lookup range is stored as text, not number.
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks