Match or Lookup

[mtapp2207]

I have a spreadsheet with two sheets. The first on has a list of numbers. The second sheet also has a list of numbers but an additional column with letters. I want to look at all the numbers on sheet 1, find them on sheet two and return the letter associated with the matching number. Thank you

Sheet 1

Find this number on sheet 2	Return corresponding number from sheet2 column b column b
100
75
25
50

Sheet 2

Find in this column	Return this
25	a
50	b
100	c
75	d

would like to see in sheet 1

Find this number on sheet 2	Return corresponding number from sheet2 column b column b
100	c
75	d
25	a
50	b

 

[Joe4]

You can do that with a simple VLOOKUP formula.
See here: VLOOKUP function - Microsoft Support

 

[Cubist]

Edited: added Joe's VLOOKUP.

Book1
	A	B	C	D	E	F
1	Sheet1				Sheet2
2	Find this number on sheet 2	INDEX/MATCH	VLOOKUP		Find in this column	Return this
3	100	c	c		25	a
4	75	d	b		50	b
5	25	a	a		100	c
6	50	b	b		75	d
Sheet12

Cell Formulas
Range	Formula
B3:B6	B3	=INDEX($F$3:$F$6,MATCH(A3,$E$3:$E$6,0))
C3:C6	C3	=VLOOKUP(A3,$E$3:$F$6,2)