I have a spreadsheet with two worksheets. One Worksheet has a list of 100 or so last names (column 1), first names (column 2) and ages (column 3).
In my second worksheet, I'd like to have a formula that returns a list of last names and first names of those over the age of 21.
I used to know how but I can't seem to figure it out now. I've tried, vlookup but can't make it work. Can someone please help me?
Thanks,
Jason B
Fairfax, VA
Bookmarks