VLOOKUP

M

Mandy

I need to create a vlookup from one worksheet to another:

If b2=one of these names, I need b3 to return the number
ENERGY 247203041
INFRASTRUCTURE 821731935
NBC UNI 450229553
CORPORATE 980222731
 
R

Roger Govier

Hi Mandy

Assuming the list shown is on Sheet1 in columns A and B, then on Sheet2 in
cell C2
=VLOOKUP(B2,Sheet1!$A:$B,2,0)
 
Top