whats wrong with this formula

[kastsnow]

=IF(MATCH(F7,Calendar!L1:R1,0),OFFSET(Calendar!L1,,,Calendar!L2:L25,),"NFG")

 

[wigi]

Perhaps

=IF(MATCH(F7,Calendar!L1:R1,0),OFFSET(Calendar!L1,,,COUNTA(Calendar!L2:L25),),"NFG")

With so few details it's as looking for a needle in a haystack.

 

[T. Valko]

=IF(MATCH(F7,Calendar!L1:R1,0),OFFSET(Calendar!L1,,,Calendar!L2:L25,),"NFG")

What are you expecting that formula to do?

 

[kastsnow]

So what I need is... If a cell sheet1!A1 = sheet2!A1 then return A2:A11 but if cell sheet1!A1 = sheet2!B1 then return B2:B11 but if sheet1!A1 = Sheet2!C1 then return C2:C11... etc until F's

does this make sense?

I have a cell in sheet one that references what day it is... 1 thru 7... I have a schedule based on which day it is that has 0:00 -23:00 that I want to populate on the first sheet depending on what day it is... I am sure MATCH OFFSET would work I just dont know how...

 

[T. Valko]

So what I need is... If a cell sheet1!A1 = sheet2!A1 then return A2:A11 but if cell sheet1!A1 = sheet2!B1 then return B2:B11 but if sheet1!A1 = Sheet2!C1 then return C2:C11... etc until F's

does this make sense?

I have a cell in sheet one that references what day it is... 1 thru 7... I have a schedule based on which day it is that has 0:00 -23:00 that I want to populate on the first sheet depending on what day it is... I am sure MATCH OFFSET would work I just dont know how...

So, Sheet1 A1 contains a number from 1 to 7?

How do you intend to use the array being returned?

Something like this:

=INDEX(Sheet2!A1:G11,0,A1)

 

[kastsnow]

ok maybe i need something else here is exactly what I have


if cell F7 in sheet 1 equals "day1" I want 15 cells of information slated below day1 in sheet2 to goto sheet 1. if cell f7 in sheet 1 equals "day 2" I want the 15 cells of info slated below day 2 brought to sheet 1... etc...

All I am looking for is a match offset of sorts. if a cell matches an array referce where the match takes place and grab the relevant information below that cell... does this help...?

can i take screenshots or upload files in mr.excel?

 

[T. Valko]

ok maybe i need something else here is exactly what I have


if cell F7 in sheet 1 equals "day1" I want 15 cells of information slated below day1 in sheet2 to goto sheet 1. if cell f7 in sheet 1 equals "day 2" I want the 15 cells of info slated below day 2 brought to sheet 1... etc...

All I am looking for is a match offset of sorts. if a cell matches an array referce where the match takes place and grab the relevant information below that cell... does this help...?

can i take screenshots or upload files in mr.excel?

OK, where EXACTLY do you want the data to appear on sheet1?

 

[kastsnow]

It dont really matter Im sure I can manipulate exactly where I want it... but Starting A2 would be just fine...

By the way thanks for your help...

 

[kastsnow]

OK, where EXACTLY do you want the data to appear on sheet1?

A2 would be fine!

TYVM

 

[kastsnow]

if cells matches cell in an array copy a range of cells below the matched cell...