VLOOKUP Duplicate help!

peter_z

Board Regular
Joined
Feb 27, 2011
Messages
87
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top