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: 
I think it depends a lot on how you have set up the data table in sheet 2.
For example you can have a column of times down the A column.and a row of MPH in the “1″ row with speeds as the data.
In the B column you can put a column 1 to whatever (65000 say)
You could put the input time in a “vlookup” to isolate the row with the “exact” appropriate time and it returns the row from column B (the table is just the first 2 columns). Then you isolate the name with a “hlookup” based on an “inexact” MPH and the table is all the columns from “C” and the row offset returned by the vlookup. You may be able to nest the 2 functions into one formula.
Alternatively you might try to do it manually while recording the keystrokes in a macro.