VLOOKUP

[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

 

[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)