ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP (https://www.excelbanter.com/excel-discussion-misc-queries/225506-vlookup.html)

Mandy

VLOOKUP

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[_3_]

VLOOKUP

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

All times are GMT +1. The time now is 12:49 PM.