VLOOKUP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillFitz - 17 Mar 2008 22:56 GMT

vlookup is not finding reference numbers from one worksheet to another in
same excel file. I have tried copying formats from lookup column to reference
column in data worksheet. I have made lookup range absolute by using $
prefixes

Reply to this Message

Chip Pearson - 17 Mar 2008 23:02 GMT

The first thing that comes to mind is that you are not using the fourth and
final parameter to VLOOKUP. It must be False. E.g.,

instead of
=VLOOKUP(1,A1:C10,2)
use
=VLOOKUP(1,A1:C10,2,FALSE)

Signature

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

> vlookup is not finding reference numbers from one worksheet to another in
> same excel file. I have tried copying formats from lookup column to
> reference
> column in data worksheet. I have made lookup range absolute by using $
> prefixes

Reply to this Message

The Greek - 18 Mar 2008 08:29 GMT

> The first thing that comes to mind is that you are not using the fourth and
> final parameter to VLOOKUP. It must be False. E.g.,
[quoted text clipped - 11 lines]
> Pearson Software Consulting, LLCwww.cpearson.com
> (email on web site)

thank you are your answer.

I actually i was using the flase parameter. However, my problem is
that when I use the vlookup for pick what coorespond to the second
largest (if the first and second largest value are equal as show
below) the formula does not pick up. Please help..

Peter: 8
John: 8
Tom: 6

I can pick up "peter" using the following fomula: =VLOOKUP(LARGE(E4:$E
$10,1),$C$4:$D$10,2,FALSE) but when I need get the second largest it
doesnt work.

thanks a lot.

> > vlookup is not finding reference numbers from one worksheet to another in
> > same excel file. I have tried copying formats from lookup column to
[quoted text clipped - 3 lines]
>
> - Show quoted text -

Reply to this Message