Need help finding a formula that I can use to reference different Columns

[Zcamaron28]

Hi Everybody,

I'm new here and I'm glad I found this place. I work with excel a lot and I have run into something that I am unsure about. If you could help that would be awesome.

I have a few thousand power readings from different days organized but I
need them split up now in days in seperate spreadsheets. They are laid out
now so that the dates go accross the top and the circuits are along the
side.

I need a formula that will switch to the next column. Like for example:

In the second screen shot It is referencing cell E79 in Strip Summary. And in the third for 11/13/06 it is referecing D79. I need a formula that I can copy and paste into new sheets that will account for that letter change so that I can make a seperate spreadsheet for each date listed in the column on the first scn shot.

\1

\1

\1


I wasnt sure what to search for so i'm sorry if this was recently posted.

[Mallycat]

It's a bit hard to follow what you are saying. Why not zip up a sample spreadsheet and post it so someone can have a look. Illustrate what you want in the sheet.

Matt

[pinmaster]

Hi

It's kind of hard to follow but I think what you're looking for is an INDEX MATCH formula.

something like: =INDEX(SHEET1!$A$1:$F$10,MATCH(A2,SHEET1!$A$1:$A$10,0),MATCH(B1,SHEET1!$A$1:$F$1,0))

Hope this helps!
Jean-Guy