Hi all,
Hopefully someone can help me![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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.
Hopefully someone can help me
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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.