Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.