offset and vlookup

[peeterparna]

I have a table where I want look up for certain values with the VLOOKU
function. When the specified value is found in the table, I want t
look up for next value from the initial table but starting from th
next row where I found the first value.

I tried to use OFFSET within VLOOKUP function to give a reference t
the new range:
=VLOOKUP(StringToBeFound;OFFSET(InitialTableRange;1;1;2;2);2;FALSE)

where, InitialTableRange can have value A14.

However, the OFFSET function gives the #VALUE error message.

Can anyone help me please?

Thanks!

Best regards,
Peeter Pärna
(e-mail address removed)

 

[Peo Sjoblom]

Use offset instead like

=OFFSET(A1,MATCH(E1,A1:A10,0),1)

where A1 is the leftmost top value, it will be the equivalent

=VLOOKUP(E1+one below if it worked,A1:B10,2,FALSE)



--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom