Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
I have two spreadsheets, I want to be able to look at names in one column on
mainframe worksheet match it to the name on the emp spreadsheet and bring back the user name. I was doing a vlooup, but the problem I am having is that the names on one spreadsheet is the full name and on the other spreadsheet it is just last and first, so my vlookup is bringing back the first one it finds. Is there a way to work around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
You can use make a new leftmost helper column on your LookupTable and
Concatenate the names together to be in the same format as on your first sheet.... Vaya con Dios, Chuck, CABGx3 "Pammy" wrote: I have two spreadsheets, I want to be able to look at names in one column on mainframe worksheet match it to the name on the emp spreadsheet and bring back the user name. I was doing a vlooup, but the problem I am having is that the names on one spreadsheet is the full name and on the other spreadsheet it is just last and first, so my vlookup is bringing back the first one it finds. Is there a way to work around this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Would this take care of a name Alexander, Pat and Alexander, Patrica Ann?
"CLR" wrote: You can use make a new leftmost helper column on your LookupTable and Concatenate the names together to be in the same format as on your first sheet.... Vaya con Dios, Chuck, CABGx3 "Pammy" wrote: I have two spreadsheets, I want to be able to look at names in one column on mainframe worksheet match it to the name on the emp spreadsheet and bring back the user name. I was doing a vlooup, but the problem I am having is that the names on one spreadsheet is the full name and on the other spreadsheet it is just last and first, so my vlookup is bringing back the first one it finds. Is there a way to work around this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Nope, not without some human intervention to make the adjustments. For these
and other reasons, is why Employee Numbers are used for doing things like this. Vaya con Dios, Chuck, CABGzx3 "Pammy" wrote: Would this take care of a name Alexander, Pat and Alexander, Patrica Ann? "CLR" wrote: You can use make a new leftmost helper column on your LookupTable and Concatenate the names together to be in the same format as on your first sheet.... Vaya con Dios, Chuck, CABGx3 "Pammy" wrote: I have two spreadsheets, I want to be able to look at names in one column on mainframe worksheet match it to the name on the emp spreadsheet and bring back the user name. I was doing a vlooup, but the problem I am having is that the names on one spreadsheet is the full name and on the other spreadsheet it is just last and first, so my vlookup is bringing back the first one it finds. Is there a way to work around this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup
Or to NOT find Patterson, Joe
Sub findpat() what = ",*pat" With Range("i1:i500") Set c = .Find(what, LookIn:=xlValues, lookat:=xlPart) If Not c Is Nothing Then firstAddress = c.Address Do c.Offset(, 2) = 3 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... Sub findpat() With Range("i1:i500") Set c = .Find("pat", LookIn:=xlValues, lookat:=xlPart) If Not c Is Nothing Then firstAddress = c.Address Do c.Offset(, 2) = 3'or whatever you want Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With -- Don Guillett Microsoft MVP Excel SalesAid Software "Pammy" wrote in message ... Would this take care of a name Alexander, Pat and Alexander, Patrica Ann? "CLR" wrote: You can use make a new leftmost helper column on your LookupTable and Concatenate the names together to be in the same format as on your first sheet.... Vaya con Dios, Chuck, CABGx3 "Pammy" wrote: I have two spreadsheets, I want to be able to look at names in one column on mainframe worksheet match it to the name on the emp spreadsheet and bring back the user name. I was doing a vlooup, but the problem I am having is that the names on one spreadsheet is the full name and on the other spreadsheet it is just last and first, so my vlookup is bringing back the first one it finds. Is there a way to work around this? |
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 |