Hey guys, I need help with a small problem.
I need to match cell A5 of sheet "PRODUCT" on sheet "SOLD" range "A:A" and sheet "BREAK" range "A:A"
I need to match it on both the sheets as the value might be entered on either sheets.
Currently I have this formulaeHowever it matches on only sheet SOLD.
Please Login or Register to view this content.
Can anyone help me?
I have attached my workbook
Is this what you wanted?
=IFERROR(IFERROR(MATCH(A5,SOLD!A:A,0),MATCH(A5,BREAK!A:A,0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hey Glenn,
Thank you so much.
It works.
Sorry for the delayed response.
Internet connection is very bad .
Thank you
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Hey Glenn,,
I need a small help.
In Post 1, i wanted to match sheet "Sold" as well.
Now i have added a new sheet "LOST". I need to do the same as above which is to match
I need to match cell A5 of sheet "PRODUCT" on sheet "SOLD" range "A:A" OR sheet "BREAK" range "A:A" , OR sheet "LOST" range A:A
I need to match it on both the sheets as the value might be entered on either sheets.
I have worked on something
When i enter this , i get a pop up saying "too many arguements". Could you please help me .Please Login or Register to view this content.
Last edited by anilpatni1234; 11-13-2018 at 09:25 AM.
Please post a sample sheet,so that I can see what's going on...
Hey Glenn, Thanks for your reply.
I have attachded my workbook.
I sheet PRODUCT , cell O5 i have entered my formulae.
However its not letting me proceed. So i have removed the "=" sign before the formulae.
Here is the formulae which i have worked on
Basically i want to match cell A5 of sheet "PRODUCT" on sheet "SOLD" range "A:A" , sheet "BREAK" range "A:A" , sheet "LOST" range A:APlease Login or Register to view this content.
Hi. Is this what you wanted?
=IFERROR(IFERROR(IFERROR(MATCH(A5,SOLD!A:A,0),MATCH(A5,LOST!A:A,0)),MATCH(A5,BREAK!A:A,0)),"")
Hey Glenn,
This works perfectly.
Thank you so much
You're welcome...
Hey Glenn,
I am facing a problem again. Sorry for troubling you.
The formulae use to work. But in sheet "LOST" i have formatted it as table. so now its not working.
Basically i want to match cell A5 of sheet "PRODUCT" on sheet "SOLD" range "A:A" , sheet "BREAK" range "A:A" , sheet "LOST" range A:A
If i dont format it as table then it works.
but now that i have formatted it as table it does not work.
ANy help?
In the attached workbook, it is not able to match text "a3" in cell "a8" of sheet "lost" with sheet "product"
Where is the non-working formula? I re-used the formula (unchanged) and it's fine. So where's the problem? See sheet....
Hey Glenn,
I rectified my error.
The formulae in my system changed to
I think that was because I deleted the page and created another.Please Login or Register to view this content.
Thank you.
Thank you its rectified now.
Thank you for all the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks