ExcelBanter - I want to enter a name then have EXCEL search a worksheet for add.

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - I want to enter a name then have EXCEL search a worksheet for add. (https://www.excelbanter.com/excel-programming/338710-i-want-enter-name-then-have-excel-search-worksheet-add.html)

rjdavis

I want to enter a name then have EXCEL search a worksheet for add.

I want to enter a name in one worksheet, then have EXCEL search a seperate
worksheet for the address that matches the name

Chip Pearson

I want to enter a name then have EXCEL search a worksheet for add.

Take a look at the VLOOKUP function.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"rjdavis" wrote in message
...
I want to enter a name in one worksheet, then have EXCEL search
a seperate
worksheet for the address that matches the name

All times are GMT +1. The time now is 09:24 PM.