Lookup function from a different sheet!

Y

Yan

I need to find all female and all male that is on 1 sheet and created the
result onto the other sheet.....

I need to take all info beside each F and created a list and Each M beside
the name a created a list into another sheet, all the information beside need
to be taken as well....

Basically,



Ex:
M Yan 252 3000
M BOB 246 25500

F Kim 256 30124
F Pat 300 25466
 
G

Gary''s Student

If you need to take an entire row of information (all males) and get it to
another sheet, use an Autofilter. You can specifiy just about any criteria
and the whole row is visible for copy/paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a list using a Lookup 2
Making a list with Lookup function 1
Lookup Value From Sheet2 1
Vlookup Function? 4
=IF(AND Function 1
Copy entire row from another sheet onto first sheet if a unique text matches 1
Extracting Specific Data from one sheet to another. 1
VLookup IF word in string exists within cell, use the word. 0

Top