Transfer of data from one table to another

Evening Gurus'

I need some help, I'm sure there is a pretty simple solution to this but I cannot figure it out.

In the first table in column A I have a location and in column C I have a unique identifier.

In the second table in Column E I have the same list of unique identifiers, in column F I have the frequencies and in column G I need the locations.

I am hoping someone can help me with a formula that will look at the unique identifier in column E, match it with the unique identifier in column C and put the corresponding location into column G.

Make sense? thought not!

Be really grateful for any assistance. Latest office BTW

Cheers
Peter

Sounds like you need to use a combination of the INDEX and MATCH functions. Use the latter to work out the position of the E value in column C and then use this result to return the correct value from column A.

Hope I understood the text, its easier if you attach an example.

Essentially the frequencies have no material effect except to quantify the extent of the problem the data analyses.

It probably is something simple, maybe I am tired!

I cant upload a picture for some reason, the page will let me browse and select the file location but then the ok box disappears so I cant upload it.

ok, thank you.

I think I have uploaded it correctly?

My ramblings may make more sense now?

Magic, Thank you so much!

Now, I don't think this can be done without some really complicated formula but I will ask anyway.

In column F where the unique references are, they are letters and numbers, lets just say they were vehicle registration numbers and I wanted a quick tally on how many has the number 10, 60, 11, 61, 12, 62 etc in them? bit like a pivot table but looking at the 2nd and 3rd digits in the unique reference but ignoring the first 2 letter of the unique reference? Is that possible or too complicated?

Sounds like I'm being lazy here but the list is over 4000 long so will take me an age to do it manually.