How can I link and match data in columns?

[davepearson]

Hi,

I am importing data from another application. I want to link columns B and C (so that these data move together) and match data in column B with data in column A. Is there any way I can do this?

A B C
1 1 235
2 3 366
3 5 120
4 6 12
5 7 452
6
7

Thanks Guys.

[Cheeky Charlie]

Perhaps you could upload an example?
CC

[davepearson]

Ive attached an example,

I wish to link columns D&E, F&G, H&I, J&K, L&M (as in keep data together).

Then match data in columns D, F, H, J and L to data in column C. (ie. Tag 4 in the respective row for Tag 4 in column C).

This would save me 100's of hours if there were a solution.

Sorry if I'm confusing you, I'm fairly new to this stuff.

Thanks again

[Cheeky Charlie]

How about this:
P4=VLOOKUP($C4,D$4:D$38,1,0)
Q4=VLOOKUP($C4,D$4:E$38,2,0)
select both cells (P4:Q4) and drag-copy across to Y4, then drag down to Y38.

Copy this table
Select D4
Paste Special - Values (Quick way is Alt+E, then S, then V, then Enter)

Repeat with appropriate range adjustments for each table
At the end, use find & replace and replace #N/A with nothing

How's that strike you?

We could write a macro to do something a bit like this if you're comofrtable with VBA.

HTH