Extract Data

  • Thread starter Thread starter Steved
  • Start date Start date
S

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
 
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
Click to expand...

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?
 
Back
Top