Help with excel function

[georgi.bogdanov]

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.

 

[CLR]

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

=VLOOKUP(A1,E1100,A2,FALSE)

Vaya con Dios,
Chuck, CABGx3