Question description:
This user has given permission to use the problem statement for this
blog.
I have 5 sheets in one workbook. Sheet 1 finds the MIN value in certain cells within the other 4 sheets. I need a formula in sheet 1 that does the following:
If MIN value was found on sheet 3, cell A5, then I need to paste data from 2 other cells (not adjacent) on sheet 3 to sheet 1.
If MIN value was found on sheet 4, then the data from 2 other cells on sheet 4 needs to go to 2 cells on sheet 1.
So whatever sheet the MIN value is found on, it has 2 cells with corresponding data that need to be pulled to 2 cells on sheet one based on the result of the MIN formula.
Thanks!
Solved by Z. Y. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/02/2018 - 11:32
Hi
Excelchat Expert
24/02/2018 - 11:33
Can you share the file please
User
24/02/2018 - 11:33
Hi. It's a google spreadsheet
User
24/02/2018 - 11:33
Does that work?
Excelchat Expert
24/02/2018 - 11:33
Sure paste the link then
User
24/02/2018 - 11:34
Phoenix - Race 2 of 18 Testing in: Default Weather, 100% track usage Matt Bussa #34
Date: Date: Date: Date: Date: Date: Date:
Setup Used: Setup Used: Setup Used: Setup Used: Setup Used: Setup Used: Setup Used:
Tire Wear: Tire Wear: Tire Wear: Tire Wear: Tire Wear: Tire Wear: Tire Wear:
Lap Time Average Lap Time Average Lap Time Average Lap Time Average Lap Time Average Lap Time Average Lap Time Average
1 1 1 1 1 1 1
2 2 2 2 2 2 2
3 3 3 3 3 3 3
4 4 4 4 4 4 4
5 5 5 5 5 5 5
6 6 6 6 6 6 6
7 7 7 7 7 7 7
8 8 8 8 8 8 8
9 9 9 9 9 9 9
10 10 10 10 10 10 10
11 11 11 11 11 11 11
12 12 12 12 12 12 12
13 13 13 13 13 13 13
14 14 14 14 14 14 14
15 15 15 15 15 15 15
16 16 16 16 16 16 16
17 17 17 17 17 17 17
18 18 18 18 18 18 18
19 19 19 19 19 19 19
20 20 20 20 20 20 20
21 21 21 21 21 21 21
22 22 22 22 22 22 22
23 23 23 23 23 23 23
24 24 24 24 24 24 24
25 25 25 25 25 25 25
26 26 26 26 26 26 26
27 27 27 27 27 27 27
28 28 28 28 28 28 28
29 29 29 29 29 29 29
30 30 30 30 30 30 30
31 31 31 31 31 31 31
32 32 32 32 32 32 32
33 33 33 33 33 33 33
34 34 34 34 34 34 34
35 35 35 35 35 35 35
36 36 36 36 36 36 36
37 37 37 37 37 37 37
38 38 38 38 38 38 38
39 39 39 39 39 39 39
40 40 40 40 40 40 40
41 41 41 41 41 41 41
42 42 42 42 42 42 42
43 43 43 43 43 43 43
44 44 44 44 44 44 44
45 45 45 45 45 45 45
46 46 46 46 46 46 46
47 47 47 47 47 47 47
48 48 48 48 48 48 48
49 49 49 49 49 49 49
50 50 50 50 50 50 50
ew
User
24/02/2018 - 11:34
Whoa
User
24/02/2018 - 11:34
one sec sorry
Excelchat Expert
24/02/2018 - 11:34
its ok
Excelchat Expert
24/02/2018 - 11:34
paste the link of googlesheet\
User
24/02/2018 - 11:34
https://docs.google.com/spreadsheets/d/1Nh4DhcK5yNYCjkfpchwWud5WtI6qRRIDby2iu8oXUys/edit?usp=sharing
User
24/02/2018 - 11:35
So on the "Master Sheet"
User
24/02/2018 - 11:35
Cell E6
User
24/02/2018 - 11:36
Needs to pull the text from the cell on the "Bussa" sheet that says "Matt Bussa #34"
User
24/02/2018 - 11:37
because the MIN value from my equation on MasterSheet! D6 found the MIN value to be on the "Bussa" Sheet
Excelchat Expert
24/02/2018 - 11:38
How do you know that it has to be from Bussa sheet?
User
24/02/2018 - 11:38
Because the MIN formula found that the min value was on the Bussa sheet
User
24/02/2018 - 11:39
in cell D6 on mastersheet
Excelchat Expert
24/02/2018 - 11:39
The other sheets have blank values now, right?
User
24/02/2018 - 11:40
correct, just building the sheet now
User
24/02/2018 - 11:40
The MIN value can come from any of the other 4 sheets. So whichever sheet its from, I need other data from that respective sheet to be put on the mastersheet
User
24/02/2018 - 11:42
For example, I put in "xx" for setup on master sheet and Bussa sheet
User
24/02/2018 - 11:42
Bussa sheet shows i used setup "xx". Since MIN value was found on the Bussa sheet, then mastersheet should show "xx" under "setup" as well
Excelchat Expert
24/02/2018 - 11:42
which cells you are counting to find the minimum values?
User
24/02/2018 - 11:44
So theres a MIN value for the best 5 lap average, 10 lap, 15, etc. So the 5 lap average finds the MIN value of the 5 lap average for all drivers (4 sheets)
User
24/02/2018 - 11:44
sorta hard to explain
User
24/02/2018 - 11:45
I could manually enter it, so if its not possible, no worries
Excelchat Expert
24/02/2018 - 11:46
Let me think a while
User
24/02/2018 - 11:50
I have to leave actually.Would you be able to email me at mattbussa34@gmail.com if you think of something before our time expires?
User
24/02/2018 - 11:50
its fine if not
Excelchat Expert
24/02/2018 - 11:51
You are registered with us?
Excelchat Expert
24/02/2018 - 11:51
In this portal?
User
24/02/2018 - 11:51
its my free session
User
24/02/2018 - 11:51
not registered
Excelchat Expert
24/02/2018 - 11:51
I am, almost sure I can send you teh solution
User
24/02/2018 - 11:52
Ok thanks.
Excelchat Expert
24/02/2018 - 11:52
SO if you can just register kindly I can send you the solution via our customer center
User
24/02/2018 - 11:52
Will do . I gotta go now. In a rush sry
Excelchat Expert
24/02/2018 - 11:52
Ok, thanks!
Excelchat Expert
24/02/2018 - 11:52
I will send you the solution
Excelchat Expert
25/02/2018 - 12:07
Here
[Uploaded an Excel file]
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.