Posts Tagged ‘Continued’
Excel Help! Search Engine Continued?
I will give this question a shot again, trying to make it a bit more clear.
In excel, I have created a Search Engine. It searches through a bunch of data and based on 3 inputs, it spits out a result.
In other words, I have the speed in MPH of a bunch of people based on where they were per second. If you input a time and speed into the search engine, it will tell you the person that was closest to this speed at the given time. So the result is the persons name and the inputs are the time and the reported MPH.
Now, suppose my search engine is in sheet one. In sheet 2, I will have bunch of reported data….a list of times and MPH of how fast I think they are going. I want to know who I thought I was looking at. Therefore, I need all my data from sheet 2 to go into my search engine in sheet 1. I will then get a reported name that I would like to appear next to my data in sheet 2.
Posted in 
Tags: 
