Inserting values?

SDSU_Jim

Board Regular
Joined
Nov 29, 2005
Messages
127
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!!!
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,118,731
Messages
5,573,889
Members
412,555
Latest member
mark84
Top