| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP
What happens if there are two of the same values in your search area when
using the vlookup funciton? Does it find the first one and use that row? It seems to be working that way but I want to make sure. Thanks, Steph |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
Yes, It's always find the first one in a range.
"steph44haf" wrote: What happens if there are two of the same values in your search area when using the vlookup funciton? Does it find the first one and use that row? It seems to be working that way but I want to make sure. Thanks, Steph |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP
Hi,
The answer is it depends, consider the following data Shane 123 Marsha 2 Shane 567 Marsha 1 =VLOOKUP("shane",F1:G4,2,1) Returns 567 =VLOOKUP("shane",F1:G4,2,0) Returns 123 So sort order and match type affect the results. If this helps, please click the Yes button. Cheers, Shane Devenshire "steph44haf" wrote: What happens if there are two of the same values in your search area when using the vlookup funciton? Does it find the first one and use that row? It seems to be working that way but I want to make sure. Thanks, Steph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| 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 | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
