If I have a list of data from A250:AM250 - I want to search to two items and where they intersect to copy that cell to paste into another sheet.
So if I were searching for "CBC" (which happens to be in L28) and "PG" (which is located in W3) I want to copy and paste into another sheets the info in cell W28.
How can I accomplish this?
That is part of a single row, which doen't match your description.Originally Posted by preseb
sorry, I am not understanding your statement
You say the two items we are looking for, exist somewhere in the range of: A250:AM250
This is a single-row range. Nothing can intersect. Am I misunderstanding your description?
A:AM is a single row?
I sorry, A1 through AM250
Thank you very much. I hope you are still there, as I have to take off in a bit and would like to help. I am not trying to be a "pain", but now if you look at your example sheet, you will see that L28 and W3 intersect at W28 (as you stated), but they also intersect at L3.
How do we know which intersecting cell to copy data from?
Posting Permissions
Reply With Quote
