How to compare two pair columns and insert value from another column

[dareme]

Hi all,

I am arranging some data and have a question that is puzzling me.

First, I have a pair of latitude and longitude located in cell M2 and N2 respectively.
Second, I have the whole list of pairs of coordinates for all locations in column R and S.
Third, I have unique code for each location in column P. For example, the pair of coordinates in R4 and S4 correspond to the unique id in P4.

My task is to find the one pair of coordinates in R and S that matches up with M2 and N2. After that, I need to paste the corresponding unique id in P onto cell O2.

For example, if R421 and S421 matches up with M2 and N2, I will then paste P421 onto O2.

Some websites suggested using vlookup but I wasn't able to use this command to compare two columns simultaneously.

Any suggestions are welcome! Thanks!

[rylo]

Hi

Try this. Expand the ranges to suit.

=INDEX(P:P,SUMPRODUCT(--(R2:R6=M2),--(S2:S6=N2),ROW(R2:R6)))

rylo