How to find 2 reference point and grab info where they intersect

[preseb]

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?

[GTO]

If I have a list of data from A250:AM250 ......

That is part of a single row, which doen't match your description.

[preseb]

sorry, I am not understanding your statement

[GTO]

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?

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?

[preseb]

A:AM is a single row?

[preseb]

I sorry, A1 through AM250

[GTO]

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?