Text i

[Tali_1]

Hello, is there something like vlookup for text. I have a list of names and I need to find their numbers from a bigger list

[#2]

@Tali_1 

LOOKUP function

VLOOKUP function

Hope I could help you with these links.

NikolinoDE

I know I don't know anything (Socrates)

[#3]

@Tali_1 

Since you are on 365 I'd use XLOOKUP()