Need Help with lookup

[matthewdbeard]

I will attach the spreadsheet with similar data for what I'm trying to do. When I pull data from this particular program I am using, it comes out dirty, and this is as clean as I 've been able to get it. What I'm trying to do is lookup some numbers from the MASTER! spreadsheet against a sheet named PWWN_ALIAS. When it finds the pwwn I'm looking for, I want it to give me the ALIAS that corresponds to that #. The problem is that they are not on the same row and the 2nd problem is that some of the names have multiple #'s that represent it. This may not even be possible but it would be the excellent if it could be done.

Thanks in advance for any help.

matthew

 

[Robert Mika]

Hi matthew,
Welcome to the board.
You can not attached a spreadsheet here unless you will use external sources.

But you cas Excel Jenie

http://www.excel-jeanie-html.de/index.php?f=1


to input some data in your topic.