Hi everyone is there any technique of vlookup whereby the very last entry is
first considered. In other words "=VLOOKUP(A1,B:C,2,0)" shall look for a
match of A1 in column B and return the corresponding value in C for the FIRST
case.

But How can I achieve the corresponding value of the LAST matching entry?

--

Best Regards,
FARAZ A. QURESHI

Try this:

=LOOKUP(2,1/(B1:B20=A1),C1:C20)

Note that you can't use entire columns as range references in (B1:B20=A1)
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
Hi everyone is there any technique of vlookup whereby the very last entry
is
first considered. In other words "=VLOOKUP(A1,B:C,2,0)" shall look for a
match of A1 in column B and return the corresponding value in C for the
FIRST
case.

But How can I achieve the corresponding value of the LAST matching entry?

--

Best Regards,
FARAZ A. QURESHI

XClent
--

Best Regards,
FARAZ A. QURESHI


"T. Valko" wrote:

Try this:

=LOOKUP(2,1/(B1:B20=A1),C1:C20)

Note that you can't use entire columns as range references in (B1:B20=A1)
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
Hi everyone is there any technique of vlookup whereby the very last entry
is
first considered. In other words "=VLOOKUP(A1,B:C,2,0)" shall look for a
match of A1 in column B and return the corresponding value in C for the
FIRST
case.

But How can I achieve the corresponding value of the LAST matching entry?

--

Best Regards,
FARAZ A. QURESHI

You're welcome!

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
XClent
--

Best Regards,
FARAZ A. QURESHI


"T. Valko" wrote:

Try this:

=LOOKUP(2,1/(B1:B20=A1),C1:C20)

Note that you can't use entire columns as range references in (B1:B20=A1)
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
Hi everyone is there any technique of vlookup whereby the very last
entry
is
first considered. In other words "=VLOOKUP(A1,B:C,2,0)" shall look for
a
match of A1 in column B and return the corresponding value in C for the
FIRST
case.

But How can I achieve the corresponding value of the LAST matching
entry?

--

Best Regards,
FARAZ A. QURESHI