MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formulas


Posted by Josie on January 28, 2002 8:41 AM

I need to search a column in a different spreadsheet for a value (NR1) and then if this value is found I need to go to the corresponding row in the adjacent column on this sheet which is the name of someone and make this name appear in my cell in the initial spreadsheet.

If there is more than 1 value of NR1 that occurs I will need to be able to have a list of names.

Is this possible?


Posted by Juan Pablo G. on January 28, 2002 9:52 AM

Check this out, might help

14469.html

Juan Pablo G.