vlookup, match or if in conditional formatting or similar
Hello,
I have two registers of files in two database systems. They are exported from both database systems into two excel worksheets.
I need to check if files are in both systems. Files must match both name and revision number. It would be perfect if it could pick up
the reference number from database 2 if there is a match and place it in list of database 1.
Please see sample attached.
Hope you can help me
Thanks!
Please see attached file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks for that, but is it possible to insert the reference Database 2 into Database 1 worksheet?
Meaning if B2 & C2 of 'Database 1' match C2 & D2 of 'Database 2', then in 'Database 1' cell D2 import value of 'Database 2' B2.
That's where I got stuck.
Could provide an example of the final result you want on the spreadsheet?
That should be the result. In 'Database 1' column D should be imported values from column B of the 'Database 2'
IF they match both - 'Database 1 Reference' AND 'Revision' in both sheets.
It only needed to change index reference. Please see attached file.
It's not working. Because each entry has a unique 'Database 2' reference number and they can not be same with any other. The formula chooses matching revision only, not the reference number in of 'Database 1'..
Ok, I see what the problem is. Please use formula below
This formula doesn't require Ctrl+Shift+Enter.
=IFERROR(INDEX('Database 2'!$B$2:$B$166,MATCH(B2&C2,INDEX('Database 2'!$C$2:$C$166&'Database 2'!$D$2:$D$166,0),0)),"Not Found")
Oh wowowow.. It works!!!!
You're welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks