Inserting values?

[SDSU_Jim]

Hi,

Just looking for some quick help on inserting values from a reference on sheet 2.
On sheet 2, I'll have a list of values like "a" in column 1 and "200" in column 2, next, below "b" in column 1 and "150" in column 2 etc. Anyone have a suggestion for a function to look at a value in sheet 1 ("a") and insert the numerical value from sheet 2 into a cell ("200")??

THANKS!!!

 

[NBVC]

Use Vlookup

=Vlookup(A1,Sheet2!A:B,2,0)

 

[SDSU_Jim]

THANKS!!
Works lots better than the nested "IF's" I was looking at!!