ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP (https://www.excelbanter.com/excel-discussion-misc-queries/180366-vlookup.html)

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

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)

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

"BillFitz" wrote in message
...
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

On Mar 18, 1:02*am, "Chip Pearson" wrote:
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)

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
* * Excel Product Group
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.

"BillFitz" wrote in message

...

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- Hide quoted text -

- Show quoted text -