Using lookup function

[noorul]

Hi

I need a lookup formula, I have a Payee sheet with the names in col E2 and I want to add the account no in col F2
Please assist

Or xlookup, basically I have added a separate sheet called Payee to my online transfer form where col E2 is the name of the payee and col F2 is the the account no

 

[etaf]

xlookup
index/match
vlookup
depending on version

What version of excel are you using for this

as mention xlookup - here is the formula

=xlookup(the name to lookup , payee!$E$2:$E$10000, payee!$F$2:$F$10000)

 

[noorul]

xlookup
index/match
vlookup
depending on version

What version of excel are you using for this

as mention xlookup - here is the formula

=xlookup(the name to lookup , payee!$E$2:$E$10000, payee!$F$2:$F$10000)

Thanks Bro

 

[noorul]

xlookup
index/match
vlookup
depending on version

What version of excel are you using for this

as mention xlookup - here is the formula

=xlookup(the name to lookup , payee!$E$2:$E$10000, payee!$F$2:$F$10000)

Thank you bro

 

[etaf]

you are welcome