Returning Partial Data using Vlookup

[Damian37]

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.

 

[frabulator]

You can use Split

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