Extract Data

[Steved]

Hello from Steved

A1 is text = Arthur St
A2 is text = Penrose High
A3 is a number = 4.0
Could somebody be kind enough to write me a lookup

The data is in the same worksheet and is the cells C4:AT125
the lookup will look for Arthur St and Penrose High to get
4.0, below is the cells that the above is in. Ok cell A3
is where I need to put the formula.

F4 Arthur St
F5 Penrose High
F6 4.0

Thankyou

 

[Harlan Grove]

A1 is text = Arthur St
A2 is text = Penrose High
A3 is a number = 4.0
Could somebody be kind enough to write me a lookup

The data is in the same worksheet and is the cells C4:AT125
the lookup will look for Arthur St and Penrose High to get
4.0, below is the cells that the above is in. Ok cell A3
is where I need to put the formula.

F4 Arthur St
F5 Penrose High
F6 4.0

So the values in A1 and A2 would always be found in C4:AT4 and C5:AT5,
respectively? If not, what's the complete and exact layout of C4:AT125?

 

[Big Chris]

See attached. I hope it answers your question.

File Attached: http://www.exceltip.com/forum/attachment.php?postid=299406 (vlookup example.xls)