Hi all,
I have a working formula which returns a value from column C:C of Sheet2 after searching and matching a value in column A, however I need to add a second match and no matter how the syntax I try it doesn't work.
The working code is below and the second match would be something like (I112=Sheet2!G:G)
Any help on how I can incorporate it would be appreciated.
Please Login or Register to view this content.
Array Formula - Requires CTRL+SHIFT+ENTER
=INDEX(Sheet2!C:C,MATCH(1,ISERROR(SEARCH(A11,Sheet2!A:A))*(Sheet2!G:G=I112),0))
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks Sixthsense, but no joy. It's returning a #N/A yet all of the values are present.
The values in I11 (I112 was my typo) and column G:G are dates but are formatted correctly, could that be an issue?
Sixthsense, I've just realised the values weren't identical and that appears to be the reason it's returning #N/A.
In my example there were two complete sets of data, would that have been the cause?
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Hi Sixthsense, I've just attached a sample worksheet with the formula's in Sheet 1 Column J. The data that we're searching and returning is in Sheet 2, and where I previously thought the issue was due to duplicates this appears to be incorrect.
In the Sample I've replaced Surnames with Sample and Test, with column G containing the match data and column C returning the data to be returned. However regardless of whether there is a single entry (Sample) or many entries (Test) it only returns #N/A.
Many thanks for looking at this for me.
Cheers
Index Match Sample.xlsx
Just Change the ISERROR to ISNUMBER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks