Merging excel spreadsheets

[thefonz22]

Was wondering if anyone could help me, or lead me in the right direction. I'll explain the problem.

Spreadsheet 1
-------------

NAME | EARNINGS
Tom | £16
Bill | £20
Frank | £15



Spreadsheet 2
--------------

NAME | Sick Days
Tom | 5
Frank | 4




Merged spreadsheet!! (this is what I want)


NAME | Earnings | sick days
Tom | £16 | 5
Bill | £20 | 4
Frank | £15 | 0


Any help would be great. This is doing my head in!

 

[JazzSP8]

Hi - Welcome to the forum

Sounds like a VLOOKUP would be what you need.

=VLOOKUP(A2,Spreadsheet2!A:B,1,FALSE)

(Making assumptions about column / row references there)

Does that help?

 

[VoG]

Try like this: formula in C2 copied down

Excel Workbook
	A	B	C
1	NAME	EARNINGS	Sick
2	Tom	16	5
3	Bill	20	#N/A
4	Frank	15	4
Sheet1

 

[thefonz22]

Thanks for the help guys, i'll give this a crack and report back.

 

[thefonz22]

Try like this: formula in C2 copied down

Excel Workbook
	A	B	C
1	NAME	EARNINGS	Sick
2	Tom	16	5
3	Bill	20	#N/A
4	Frank	15	4
Sheet1

GENIUS! Problem solved. many thanks!