Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |