Sheet in which the next column gets automatically filled

[Closed]
Report
Posts
1
Registration date
Tuesday July 14, 2015
Status
Member
Last seen
July 14, 2015
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hi
I need an excel sheet in which the next column gets automatically filled the moment existing cell is filled.Suppose, I have 10 employee names and the moment I fill the entire 10 rows with the names, the next column with the Employee ID gets automatically for the corresponding names.
thank you

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi JyotirmoyGuha,

The VLOOKUP formula will look for a value (employee name) in a matrix (a table with employee names and ID's) and then return the value of a chosen column in the matrix.

Try it and let us know if and where you get stuck.

If I didn't understood you correctly then please provide a sample of your data for better understanding.

Best regards,
Trowa