Very very confused with searching for rows

Hi there, Ive been on here once or twice before and you guys have helped me out a bunch. I really appreciate it. I am coming just one more time for help. Say I have two sheets. Sheet one is blank, and where I want to put my function....Sheet two has imported weather data through a web query. Each row in the 2nd sheet has a weather variable on it (temp, wind, humidity, etc). However, the actual data and label for the data is in one cell. Also, with the querys, the data order changes. Sometimes the temp is int he first row, sometimes its in the 2nd row. Say I am in A1 in the first sheet and i want to get the temp value from the 2nd sheet.. How do i go about making it search each row until it finds the word "Temp" then giving me the value after it? I am familiar with the MID and VALUE functions, so getting the numbers from the string of text isnt really the problem, its just having the cell from sheet one find the temperature row on sheet two. Any ideas? Thanks!

HI

Try something like this.

=SUBSTITUTE(INDEX(Sheet2!A:A,MATCH("*temp*",Sheet2!A:A,0)),"temp","")

Can't be sure of how much is in the cell that contains temp so you will probably have to manipulate. If you remove the SUBSTITUE function part, you should get the full text from the data sheet.


HTH

rylo

It worked. You guys amaze me. haha. thanks again. one last quick question. say if Temp was in A1 and the actual temp was in A2, how would i have it search for "Temp" and return the value in A2?

Hi

Try

=INDEX(Sheet2!A:A,MATCH("*temp*",Sheet2 !A:A,0)+1)


rylo

Wow. Thanks. everythign works perfect. I tried self-learning all the functions for excel, and still wasnt sure on a few, and of course, the ones needed, i was confused about. thanks so much. its very much appreciated!