HELP!! Need a formula to test for multiple conditions and bring back numbers with same

Greetings, I might be explaining this poorly.

I have a two tabs (March & April) column with Order numbers and due dates (with Item numbers, amount etc.)

I am trying to compare both tab data by Order Numbers with due dates, if any changes in due date in April tab I want to see old due dates from March tab with same order number line and old due date.

I can understand in VLOOKUP if order has duplicate values it only finds the first in the list, any chance "please can I have a formula which look or base more condition like other column details (item no. e.g.) to bring the same line information from other tab".

I would really appreciate any kind of help or if there is any idea to make it more handy or more clear.

Thanks for help
(attachment 20KB) took half an hour not sure its uploaded if not I will keep try to upload

link to upload file
https://samepage.io/ce4f72d019a0231d1e3e66c8758ea8923c534c23/file/232630727492118757/OBook.xlsx

Yes we really need to see the workbook.

You may find concatenating the order number and due data into a new helper column will then allow you to use an =INDEX(MATCH()) compound formula.

please find link to upload file

https://samepage.io/ce4f72d019a0231d...757/OBook.xlsx

username for link & passwords is

username: [email protected]
password: excelforum

and web page to login https://samepage.io/login?r=https%3A...-my-first-page

please login to webpage and than use username & password

any problem please let me know

thanks

the link ask for a username. add the file on the forum instead.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

The link is looking for authentication...

hi thanks for reply,

step 6 doesn't working for me, upload manger keeps refreshing or on wait mode!!!

username for link & passwords is

username: [email protected]
password: excelforum

and web page to login https://samepage.io/login?r=https%3A...-my-first-page

please login to webpage and use username & password
Cheers

@raysrains

Try to post on the forum, you will get better help that way.

Is the file too big? (> 1 mb)

We only need a small excel file.

Please also add the expected result in your file.

OK. I have it; but I'm not that clear as to what you want. In April column D, you want the corresponding date from column B (or other??) in March. However, the same Order can be associated with several rows. Would it be OK to link the order nmber and the item number, and on that basis - return the due date from March Column B?

My Q boils down to this:

Can the item number (Column C) appear twice in relation to one order number?

If the answer is NO, then use this formula in April/D3, copied down:

Formula:

Please Login or Register  to view this content.

I tried to attach your file, but (despite being small) I couldn't do so. try aagain.

No it won't attach. Try the formula supplied earlier and let me know.

This is a new EF fault. I can't get to see the last post!!!