Ok, good deal!

--
Biff
Microsoft Excel MVP


"Alfredo_CPA" .(donotspam) wrote in message
...
Thanks for your input. I was able to figure it out with Bernard posting
--



"T. Valko" wrote:

Will the result of the lookup formula be the *only* entry in column R?

Once we have the "rules" on how to find the variable cell there should be
no
problem getting the result you're looking for.

I'm also assuming that the offset, 5 rows, -13 columns is *relative* to
the
variable cell?

--
Biff
Microsoft Excel MVP


"Alfredo_CPA" .(donotspam) wrote in message
...
R39 is a variable, is not always R39, rather than refering to a
constant
cell, I need to refer to "the cell that contains the result of my
Vlookup",
which could be whatever row in column "R")

--
I''''''''m not a looser, I keep trying.


"T. Valko" wrote:

Maybe this:

=OFFSET(R39,5,-13)

--
Biff
Microsoft Excel MVP


"Alfredo_CPA" .(donotspam) wrote in message
...
I have a simple vlookup function that works fine.

Now I need excel to give me the value wich is in the intersection of
5
rows
down and 13 clolumns to the left of the cell wich contains the
output
of
the
vlookup result. (i.e. if the value of the output of the Vlookup is
in
R39,
now I need a formula that gives me as result the value in E44)

Any idea of how to perform this?

Thanks
--
I''m not a looser, I keep trying.