I am trying write a formula for when I enter in the machine number the machine name populates with the correct machine name

[Sargent12]

I am doing about 1000 lines of data entry for a machine shop and I am trying write a formula for when I enter in the machine number the machine name auto fills with the correct machine name.

Program	Hours	Machine Number	Machine name
Program 1	2
Program 1	3
Program 1	5
Program 1	8
Program 1	1

Machine #	Machine Name
1	Grinder
2	CNC mill
3	H Lathe
4	V lathe
5	CNC lathe
6	Band saw
7	Sander

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Program	Hours	Machine Number	Machine name		Machine #	Machine Name
2	Program 1	2	6	Band saw		1	Grinder
3	Program 1	3	4	V lathe		2	CNC mill
4	Program 1	5				3	H Lathe
5	Program 1	8	1	Grinder		4	V lathe
6	Program 1	1				5	CNC lathe
7						6	Band saw
8						7	Sander
Data

Cell Formulas
Range	Formula
D2:D6	D2	=XLOOKUP(C2,$F$2:$F$8,$G$2:$G$8,"")

 

[Joe4]

Since you already have the lookup table, this can be done easily with a VLOOKUP function.
See: VLOOKUP function - Microsoft Support