Excel formula help, please.

[lmgtfy]

I've been trying to work out how to do this for a while now and I'm sure for someone who knows what they are doing it would be simple enough just like most things. I've tried VLOOKUP but that seems like it needs you to enter a value to lookup as such.

 

Anyway if anyone can help I'd appreciate it. So I have two sheets one with full name and some other data and a second sheet with full names and email addresses. What I want to do is match the full names and then if they match copy the email address across into sheet 1.

 

So current it looks like this

 

 

Thanks

[MatthewL]

=VLOOKUP(C2,Sheet2!A:B,2,FALSE)

[lmgtfy]

=VLOOKUP(C2,Sheet2!A:B,2,FALSE)

 

Wow that was quick! I'm glad I was on the right lines with the VLOOKUP I just couldn't work it out embarrassingly.

 

Thanks very much for your help :-)

[TechMonkey]

I think it is impressive no one posted a lmgtfy link

[ITGuyNW]

I wanted to know the formula yesterday for using an if error with averages and vlookup. Asked ChatGPT and it came back with the right answer straightaway.

[MatthewL]

I found this site recently, looks like its changed and I think it was via here called Excel formula bot.

 

That VLOOKUP is one I frequently do so was easy enough to sort.

[Ditto]

If you are on later versions of Excel, (M365 version for example), there is a new function called XLOOKUP. Well worth learning as it'll do everything VLOOKUP does and more.

[simonw]

If you are on later versions of Excel, (M365 version for example), there is a new function called XLOOKUP. Well worth learning as it'll do everything VLOOKUP does and more.

Is that for past relationships?

 

[ITGuyNW]

If you are on later versions of Excel, (M365 version for example), there is a new function called XLOOKUP. Well worth learning as it'll do everything VLOOKUP does and more.

 

Yeah the XLookup is very handy. Infact so handy, we had to reinstall Office for staff from pro plus to 365..

[MatthewL]

Handy to know, not available on my home version but is on my work laptop, will have to have a play on that.

[Ditto]

Is that for past relationships?

 

Definitely about relationships, but could be past, present and future.