Evaluating a # Lookup Value to get an element in the Range matching the number.!
Dear Forum,
I am aware of using VLOOKUPS and INDEX and MATCH functions individually and also in combination however, I would like to know whether is there a possibilty of using the Numeric answer to get the Value which has no connection with the Number unlike in any LOOKUP function where we use the actual lookup value to match in the LOOKUP range..
What I mean is, lets say if there are just 15 values which are the Column Headings from lets say $G$1:$U$1...
and I want to get the Column headings as my answer depending on the number that I get from another expression..
Lets say if my numeric lookup value is 2 then I need to get the answer as the value in the cell H1, if it were 14 then the value in the cell T1 which is the 14th cell in the selection if i were to consider it from $G$1:$U$1..
I know that the CHOOSE function is the most appropriate function however it does not take the entire range as its Value, so is there any other function which I can use in this scenario..
Imagination:
=CHOOSE(Lookup_Value,$G$1:$U$1) can this be made possible?
Warm Regards
e4excel
Bookmarks