Vlookup Problem

[stephen.smith]

Hi Guys I have a small problem with a lookup formula.
I am trying to perform a lookup formula that will look in cells B5:G5 for the number 2 which in turn will return the value I have placed 2 rows below in the corresponding column. e.g. if the number 2 is in cell E5, i would like the lookup formula to find the value that is in cell E7. If there is a different formula needed please let me know.
Thanks In Advance. I have a feeling that there is an easy answer to this however i dont know how to make it work.
Thanks
Stephen

 

[scottylad2]

Excel Workbook
	A	B	C	D	E	F	G	H
3	pink	2		1	3	6	2	5
4
5				red	green	blue	pink	orange
6
Sheet1

[/B]