How to find extract information from a table

[kwyang]

Hi all,
Hopefully someone can help me

I'm trying to extract information from a table.
If I insert the Employee ID, it should provide the Name and Email in separate cell.

Insert Employee ID here > [ ] , result > [Name],

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee ID[/TD]
[TD]Name[/TD]
[TD]Gender[/TD]
[TD]Email[/TD]
[TD]Contact[/TD]
[/TR]
[TR]
[TD]120391[/TD]
[TD]Chao [/TD]
[TD]Male[/TD]
[TD]chao123@email.com[/TD]
[TD]9403121[/TD]
[/TR]
[TR]
[TD]120392[/TD]
[TD]Amanda[/TD]
[TD]Female[/TD]
[TD]amanda123@email.com[/TD]
[TD]1920301[/TD]
[/TR]
[TR]
[TD]120393[/TD]
[TD]Alex[/TD]
[TD]Male[/TD]
[TD]alex123@email.com[/TD]
[TD]1203019
[/TD]
[/TR]
[TR]
[TD]120394[/TD]
[TD]Alice[/TD]
[TD]Female[/TD]
[TD]alice123@email.com[/TD]
[TD]1203102[/TD]
[/TR]
</tbody>[/TABLE]

My thoughts is to use VLOOKUP and IF, but it doesn't really work out for me.

Your help would be much much appreciated.

 

[Joe4]

Not sure what you would need IF for. It should simply be a matter of two VLOOKUPs, one for Name and one for Email.
What part is tripping you up?

 

[Marcílio_Lobão]

Kwyang, Good morning.

Suppose your data at A2:E5

G1 --> Insert Employee ID

H1 --> =VLOOKUP(G1, A2:E5, 2, FALSE)

I2 --> =VLOOKUP(G1, A2:E5, 4, FALSE)

Is that what you want?

I hope it helps.

 

[kwyang]

Thank you both Marcílio_Lobão and Joe4.
Appreciate it, got it running now.

Just realized I have no idea how Vlookup works before this

 

[Joe4]

Here is a good write-up, if still needed: https://www.techonthenet.com/excel/formulas/vlookup.php

 

[Marcílio_Lobão]

Kwyang, Good afternoon.

Glad to have helped you.
Thanks for the feedback.