Hi all,
I am trying to match two conditions from one sheet to match two columns from another sheet and if so return data in a third cell.
I think the formula is nearly there but I am returning the incorrect data.
Any help would be appreciated.
Thankyou
See example.
Not sure wahy you are using MIn
Try this
=IFERROR(INDEX('SDP''s'!$D$2:$D$34,MATCH(1,IF('SDP''s'!$A$2:$A$34=Operations!$A2,IF('SDP''s'!$C$2:$C$34=Operations!$C2,1)),0)),"")Drag down
Confirm COntrol+SHift+Enter
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Thanks for your reply but when I drag down the formula it throws up the error.
"You cannot change part of an array."
I am pulling the plus at the bottom right of the cell down
Did you enter the formula in once cell or in all at once?
A assuem is the second option.
Enter it to first cell only and then drag down.
Ah thats correct the cells were already filled in.
I just deleted all pervious data in the cells below and resubmitted the formula.
Thanks very much for your help
You are welcome.
Thanks for rept.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks