Help with moving values from cell to cell sheet to sheet

[Rhuumz]

10minTemplate.xlsx

Hey All,

I need a bit of help with the above spreadsheet I am making.

What I am trying to do in plain English is compare cell D8 with Sheet2 C3:AG3

if the 2 numbers match take a value from the sale column and place it in another.

eg. "Sheet1 D8 = 8 compares all the values across Sheet 2 and finds that J3 = 8 looks down at J6"target unit" and then takes that value and inputs it into Sheet1 B17"

[FDibbins]

"Sheet1 D8 = 8

Sheet1 D8 = 1, not 8?

[FDibbins]

I think this is what you want, but the row "headings on each sheet need to be identical...
=INDEX(Sheet2!$A$3:$AH$11,MATCH($A17,Sheet2!$A$3:$A$11,0),MATCH(Sheet1!$D$8,Sheet2!$A$3:$AH$3,0))

So you need to change "daily Target" to "Target Units" (or vice versa)

[Rhuumz]

Sheet1 D8 = 1, not 8?

Yes it does I was just giving 8 as an example. the Field in D8 will be changed daily to reflect a working day

[FDibbins]

Yes I figured that after I went deeper into what you wanted (I guess Im a very visual kinda guy lol)

[Rhuumz]

Sorry that didnt work. I probably should have also mentioned that the formula will be in B17.

So B17 looks at D8 to see what working day it is... Then matches the day with the same day on sheet 2 across C3:AG3 once its found the same day looks down at the corresponding value in row 6 and then places that number back into B17

[FDibbins]

Sorry that didnt work.

what didnt work?

with 1 in sheet1 D8, I put xx in sheet2 C6, and thats exactly what i got for an answer in sheet1 B17?

[Rhuumz]

Ah yes thank u kimosabe!

I spelled the Daily target title wrong and then it worked!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.