Index and Match across two different workbooks
Hi everyone,
I really hope someone will be able to help me here.
I'd like to find out if cell A2 in Workbook1.xlsx (Let's say it's a text that says "Car") is a duplicate across the whole column A of another workbook: Workbook2.xlsx
I have come up with the following formula so far, but it's not exactly working, because it doesn't search across the whole column A:
=INDEX([Workbook2.xls]Sheet1!$A:$A, MATCH(A2, [Workbook1.xlsb]Sheet1!$A:$A, 0))
Any ideas?
Thanks
=COUNTIF ([Workbook2.xls]Sheet1!$A:$A , A2)
but will not work if workbook is closed
nor will index() work on closed workbooks
you need index.ext (which is a add-in)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Unfortunately I get #VALUE!Originally Posted by etaf
with both the workbooks OPEN ?
Yes.
I am trying to find out if the data in cell A2 in Workbook 1 appears both in Workbook1 and anywhere in Workbook2
Last edited by evans1; 01-25-2017 at 01:32 PM.
then the count will work across open workbooks - and you will get a 1 or greater depending on how many times its in the 2nd workbook
what are the workbook names ?
are they in the same folder on the PC
and can you then post the formula you are using
Apologies, the formula does work.
Thank you so much.
you are welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks