Excel Function Ask

[vutrongminh16]

Hello, I want to ask for the specific excel function that will help me find the value of the part number that I created.

For example, I will create a 2 column Part Number/ Code. I then assign one part number with one code. In addition, the list will be very long ( about 500 rows) so I want to know if I got one of the part number, What excel function I should use to get the code. Remember Part number is input and Code is output and the table should be included to get the code as well. I know there is more than 200 excel function and I have no idea to know what function I will use. Thank you so much

 

[mikerickson]

It sounds like you need VLOOKUP

=VLOOKUP("S-L-5-15-S-W", A:B, 2, False)

 

[vutrongminh16]

that's awesome, thank you so much

 

[johnnyL]

Book1
	A	B	C	D	E
1	Part Number	Code		Part Number to Search	Matching Code
2	S-L-5-20-S-W	5432W		S-L-6-30-S-W	5423W
3	S-L-5-15-S-W	5431E
4	S-L-6-20-S-W	5415K
5	S-L-6-15-S-W	5231U
6	S-L-6-30-S-W	5423W
7
Sheet1

Cell Formulas
Range	Formula
E2	E2	=VLOOKUP(D2,A2:B6,2,FALSE)