I have some data reports that I am responsible for, and in a time crunch, so I am trying to find away to make it a little easier to get the data I need. I am having problems uploading the doc, so I will do my best to explain what I would like to make happen, may not be possible but here goes. On Sheet one I have a list of Cities in Column C, WAS, STL, CHI, OAK etc. Also in Sheet one, in Column K, I have either HF, HD, AF, or AD depending on certain criteria. In Sheet 2, in Column R, I have all the citites listed again, and then I have seperate Columns for HF, HD, AF, and AD, They are AK though AN respectively. These cells in these columns can either be blank, or will have POS or NEG in each. The blank just respresents that no data came in that day. Ok now for what I 'd like to be able to accomplish, but not sure it's possible. Somewhere on Sheet 1, I would like a formula to look at the city name, and then if it's HF, HD, AF, or AD. Then go into sheet 2, find that city in Col C, and then the corresponding HF, HD, AF or AD column, and return the last 5 data filled cells. I think it's probably asking to much. So as an example: On Sheet 1 STL is in Colum C, HF is in Column K, go to sheet 2 column R, find STL, find look in Col AK for HF, and then return the last data occurences starting from the bottom of the HF Column going towards that top. The top of the column is later dates. Sorry if it sounds complicated, I am trying to upload a doc to make it easier. I think it's asking too much from excel though.. but thought I would check. I realize that if the data cant be returned to sheet 1, I am guess it would have to spread over 5 consecutive cells..
Bookmarks