ExcelBanter

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

[email protected]

help
 
Trying to figure out how to do this. Lets say I have a large excel
workbook...maybe 20 pages.....100 rows in each.
I want to look up a name in column B....and return all of this name
along with the data in an adjoining column. Hope this makes sense.
Thank you.

Michael

Hi
You haven't really given us much to go on. But if all of your data lines
have a unique identifier, you could use VLOOKUP to do your searching.
Maybe if you supplied more info, examples, etc. the answer would be more
specific.
Regards
Michael Mitchelson


" wrote:

Trying to figure out how to do this. Lets say I have a large excel
workbook...maybe 20 pages.....100 rows in each.
I want to look up a name in column B....and return all of this name
along with the data in an adjoining column. Hope this makes sense.
Thank you.



All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com