| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using 'if" To Return An Entire Row?
Hello all!! :) Is there an "if" formula (or any other) that will return an entire row? For example: Column A has my salespersons names Columns B - J have other info i have my "master list" of all contacts, and then I have a separate sheet for each of my salespeople. What formula would i use (if it is even possible) to have excel look for "Mike" on the master sheet & then return all the other info next to his name onto "Mike's sheet" each time it sees his name ? Let me know if i need to explain that more clearly! Thanks in advance for your time & help! Jenny -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=515943 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Monthly Stock Return Volatility | Excel Discussion (Misc queries) | |||
| want to return "n/a" or "0" | New Users to Excel | |||
| If (either of these) return this | Excel Worksheet Functions | |||
| Return lowest quantity | Excel Worksheet Functions | |||
| RETURN intersecting value with known horizotal & vertical?? | Excel Worksheet Functions | |||
Threaded Mode
