Splitting two parts of a concatenation

[Matt_Chelmsford]

Excel 2010

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1								Alpha	Brava	Charlie	Delta	Echo	Foxtrot	Golf
2							Cat	8	5	4	4	9	8	4
3	Alpha cat	8					Dog	3	5	5	3	9	9	6
4	Alpha parrot	9					Fish	2	6	8	9	9	6	9
5	Delta fish	9					Parrot	9	8	5	8	5	5	9
6	Alpha cat	8					Hampster	9	2	4	9	9	9	5
7	Echo Hampster	9
8	Delta Cat	4
9	Golf Cat	4
10	Golf parrot	9
11	Alpha Hampster	9
12
Sheet2

I am struggling to get a formula that will return the value from a table based upon a concatenation. I want a formula in column B and be thankful for your help.

Regards
Matt

 

[Andrew Poulsom]

In H2 copied down and across:

=VLOOKUP(H$1&" "&$G2,$A$3:$B$11,2,FALSE)

 

[Peter_SSs]

I want a formula in column B

I'm reading that the other way to Andrew, so I think this may be what you want.
Formula copied down.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1								Alpha	Brava	Charlie	Delta	Echo	Foxtrot	Golf
2							Cat	8	5	4	4	9	8	4
3	Alpha cat	8					Dog	3	5	5	3	9	9	6
4	Alpha parrot	9					Fish	2	6	8	9	9	6	9
5	Delta fish	9					Parrot	9	8	5	8	5	5	9
6	Alpha cat	8					Hampster	9	2	4	9	9	9	5
7	Echo Hampster	9
8	Delta Cat	4
9	Golf Cat	4
10	Golf parrot	9
11	Alpha Hampster	9
Lookup

Matt, when using the HTML maker, look for options of which formulas to show (First line only, no formulas, user-defined selection etc) to reduce the size of your post.
Huge tables like that make your post & the thread hard to read/navigate.

 

[Andrew Poulsom]

I'm reading that the other way to Andrew

Yeah, too hasty.

 

[Peter_SSs]

Matt, when using the HTML maker, look for options of which formulas to show (First line only, no formulas, user-defined selection etc) to reduce the size of your post.
Huge tables like that make your post & the thread hard to read/navigate.

I've replaced your table. Hope you don't mind.