ExcelBanter - Lookup and Copy Data

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup and Copy Data (https://www.excelbanter.com/excel-worksheet-functions/176863-lookup-copy-data.html)

fruitchunk

Lookup and Copy Data

In column A I have a list of names
In column B I have a list of id# numbers

In column D I have a list of some names of column A

Now I need a formula to lookup the id# numbers in column B and copy it to
column E matching to the names

Please help

Gaurav[_2_]

Lookup and Copy Data

=VLOOKUP(D1,$A$1:$B$10,2,FALSE)

adjust the range as per the requirement.

"fruitchunk" wrote in message
...
In column A I have a list of names
In column B I have a list of id# numbers

In column D I have a list of some names of column A

Now I need a formula to lookup the id# numbers in column B and copy it to
column E matching to the names

Please help

All times are GMT +1. The time now is 06:08 AM.