# VLOOKUP Duplicate help!

#### peter_z

##### Board Regular
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

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
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?

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.

Replies
1
Views
261
Replies
5
Views
180
Replies
3
Views
614
Replies
20
Views
637
Replies
2
Views
800

1,211,839
Messages
6,104,290
Members
447,901
Latest member
boy3hc2004

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back