I am trying to accomplish a reverse vlookup using Excel 2010. Here is what it looks like.
I have a table with 5 columns and 25 rows. The 2nd through 5 columns are the raw data that I want to sort through, returning the data in column 1. The two variables (held in other cells) is which column to look at and what the number I am looking for (the number must be less than or equal to the raw data in the column). Then it spits out the resultant from column 1. I can reorder the columns but do not want to break up the table into 4 separate tables.
What sort of function can be used for this? See below for an example.