Finding & Returning Cell data in a column

[rpolasky]

Hello guys & gals,

I tried using the search section and I'm not really finding what I'm looking for, so I will try to ask it here. (and if there is a topic on this same thing please redirect me)

Sheet 1 A1-A3 is where I would like to place a specific text item from Sheet 2 Column A.

In Column A on Sheet 2 There is random text throughout the column. This data changes every time I use my macro button to pull in data from a website.

What I am trying to do is find the cell that start with "TAF" & the coresponding cells below ( all the becmg texts )

I cant just do a sheet 1 a1 = sheet 2 specific cell because sometimes the "TAF" portion changes to a different row #.

Is there a way to find "TAF" in column A in sheet 2 and take all the text in that column and put it in Sheet 1 A1, and then take everything below that and put in on sheet 1 as well?

Below is a picture of "sheet 2" ... sheet 1 you can imagine is blank.

Thanks!

RP

 

[Aladin Akyurek]

I put it in there just as you said, and it returned the lines above the "taf" line ( METAR, etc ) I need the TAF line itself and below.

I think it has to do with something in the INDEX portion of the formula, because it did work as intended... just Up not Down.

I get the down part...

https://dl.dropbox.com/u/65698317/aaSublist%20Public%20rpolasky.xlsx