How To look up a value from a table with sub-column

[Redmondcys]

I understand the basic that vlookup can look for the value on the first column and return the cell next to it.

Like if on the other sheet, I manually input in separte cells as "room 1", "A", "A1", and I want it to return "value1" for me.

Please help...

	A	A	B	B
	A1	A2	B1	B2
room 1	value1	value4	value7	value10
room 2	value2	value5	value8	value11
room 3	value3	value6	value9	value12

<tbody>
</tbody>

 

[T. Valko]

One way...

Sheet1

	A​	B​	C​	D​	E​
1​		A​	A​	B​	B​
2​		A1​	A2​	B1​	B2​
3​	room 1​	value1​	value4​	value7​	value10​
4​	room 2​	value2​	value5​	value8​	value11​
5​	room 3​	value3​	value6​	value9​	value12​

Sheet2

	A​	B​	C​
1​	Room 1​	A1​	value1​
2​	------​	------​	------​

This formula entered in C1:

=VLOOKUP(A1,Sheet1!A2:E5,MATCH(B1,Sheet1!A2:E2,0),0)

 

[Redmondcys]

many thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[T. Valko]

You're welcome!