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)

--
Regards
Roger Govier

"Mandy" wrote in message
...
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