Help with excel function
 

Hello,
I need some help with a function in excel so pls if someone knows how
I'd really appreciate the help.
So here goes, I'll try to explain it the best i can:


E | F | G | H | ...
| O |
| 1 | 2
| ... | 9 |
7| 24.5 | | 36 | 15 | ...
| 74 |



What I'm looking for is a function that will search for a given
text (for example 24.5) and return one of the values from this row
from G-O columns on the same row based on the number entered in
another cell (numbers 1-9).
I guess the part with the G-O columns can be done with select case
and i saw several examples of how to search for a text in a number of
cells but I've no idea how to link the search to return the data from
G-O columns.

Thanks in advance.

Help with excel function
 

The following formula will look up the value of cell A1 in the array of
E1:o100, and step over the number of columns to the right as is the value in
cell A2......perhaps this will do you.

=VLOOKUP(A1,E1:o100,A2,FALSE)

Vaya con Dios,
Chuck, CABGx3




" wrote:

Hello,
I need some help with a function in excel so pls if someone knows how
I'd really appreciate the help.
So here goes, I'll try to explain it the best i can:


E | F | G | H | ...
| O |
| 1 | 2
| ... | 9 |
7| 24.5 | | 36 | 15 | ...
| 74 |



What I'm looking for is a function that will search for a given
text (for example 24.5) and return one of the values from this row
from G-O columns on the same row based on the number entered in
another cell (numbers 1-9).
I guess the part with the G-O columns can be done with select case
and i saw several examples of how to search for a text in a number of
cells but I've no idea how to link the search to return the data from
G-O columns.

Thanks in advance.