Vlookup & Output off Day of Week

[maverickballa24]

In this example below I am neeeding a formula that will go in sheet 1 in the column before each date. The formula should use a vlookup of the center # off of sheet 1, find that center number in sheet 2 then output the center day decimal that would match the current day. Monday is Center#+.1, Tuesday is Center #+.2, etc.

Sheet 1:
Center 340
12:00 AM
? Monday 0.00 0.00
? Tuesday 0.00 0.00
? Wednesday 0.00 0.00
? Thursday 0.00 0.00


Sheet 2
Center Day Decimal Center Day ID Day of Week Totals
103.1 103 1 Mon 62


Thanks

Scottie

[FDibbins]

Hi and welcome to the forum

Its a little hard to make out where your data starts and end when you copy/paste like that.

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[maverickballa24]

I have attached the file that demonstrates what I am looking for.

[Jonmo1]

Try this on Sheet1 B4 and filled down
=INDEX(Sheet2!$A$2:$A$8,MATCH(B4,Sheet2!$D$2:$D$8,0))

Make sure to make the Weekday formats match on both sheets.
You have Monday Tuesday Wednesday on Sheet1, but just Mon Tue Wed on Sheet2.
They should be the same.

[Jonmo1]

Actually, given your sample book, in Sheet 1 B4 you could just use

=Sheet2!A2
And fill down.

[maverickballa24]

Actually I will have to use the index cause in the sheet 1 have it where you type in a certain district.. Then outputs all the center numbers in the format as shown in sheet 1 with repeated values for the days of week and center. Sheet 2 contains all data for the information through the day. So i need for it to look for the center number in the list of all center numbers and outpt the appropriate day decimal equivalent. Let me try Index and see if that works. Thank you very much!!

[Jonmo1]

The book you posted only has 1 center shown.

Please post a book with enough useable sample data to formulate a solution.

[maverickballa24]

I have reattached the file.

[Jonmo1]

Is this going to be 'expanded' to include a lookup based on the District as well?
If so, might as well include that in your sample file also.

[loginjmor]

Hi -

Attached is a solution. You can change the Center Number or the decimal daily increment to create whatever daily decimal equivalent you want.

Hope this helps.

[maverickballa24]

Ok I added the district piece also. Essentially you type the district number in Sheet 1 it populates all center numbers in the following format on sheet 1 from sheet 3. It in return must read the day of week for the correct center number from the raw data which is sheet 2. So a vlookup of the center number and an output of the appropriate decimal equivalent is what I am
needing. Thank you for your help!!

[maverickballa24]

Ok i just noticed that the count on sheet 3 didn't pull. It pulls all centers in that district in order. This is then outputed to sheet 1.

[Jonmo1]

are you just trying to add the .1 .2 .3 .4 etc to the center number based on Monday Tuesday Wednesda etc ??

[maverickballa24]

Yes i am essentially trying to run a vlookup of Sheet 1 cell C2 & C12 lookup of Sheet 2. , once it reads the center number output the appropriate decimal equivalent for that day. So Monday should be the center #+.1, Tuesday should be Center+.2, All outputed in Column A.

[Jonmo1]

Seems way over complicatd to have to look that up from another sheet.

Why not just do something like this in A4
=C$2+(ROWS(A$1:A1)/10)

Then in A14
=C$12+(ROWS(A$1:A1)/10)

[maverickballa24]

That will work. You are right I was over complicating it great. It is a Friday!!! lol

Thank you very much!!

[Jonmo1]

Great, glad to help.