whats wrong with this formula

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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.
 
Upvote 0
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...
 
Upvote 0
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)
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,224,542
Messages
6,179,421
Members
452,913
Latest member
JWD210

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top