Extract Data

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

"Steved" wrote...
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?

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.

See attached. I hope it answers your question.

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

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/