VLOOKUP Duplicate help!

[peter_z]

Hey guys, I have looked around on google but just can't seem to get this right.

I am trying to link long and lat figures.
I have concantenated it already here is a sample of my data:

Tab 1 -
Column A Column B
LONG35.2LAT173.6 0462
LONG35.2LAT173.9 0245
LONG35.2LAT173.9 0246

Tab 2 -
Column A Columb B Earthquake Strengths
LONG35.2LAT173.6 7
LONG35.2LAT173.9 6

I need to reference all the post codes from columb c for tab 2.

Cheers guys

 

[Robert Mika]

Is your answer going to be the 0245 & 0246 next to LONG35.2LAT173.9 6 in the bottom table?
If not can you post example?

 

[PCRIDE]

Vlookup only works when there are no duplicates. It will only find the first one in the table. I am not sure if thats the problem your having.