Returning Partial Data using Vlookup

Damian37

Board Regular
Joined
Jun 9, 2014
Messages
189
Hello Everyone,
I was wondering if anyone might know how to return only partial data using Vlookup. I would like to only bring back the first name instead of the full name when doing my vlookup. Thank you for any help anyone can give me. Thank you.

D.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

frabulator

Board Regular
Joined
Jun 27, 2014
Messages
107
You can use Split

Code:
Sub NameCatcher()


Dim LookInHere As String
Dim Counter As Integer
Dim SplitCatcher As Variant
Dim FirstName As String
 
LookInHere = "FName LName"
 
SplitCatcher = Split(LookInHere, " ")

FirstName = SplitCatcher(Counter)

MsgBox (FirstName)


End Sub
 

Forum statistics

Threads
1,089,165
Messages
5,406,555
Members
403,095
Latest member
cyclingdad

This Week's Hot Topics

Top