Hi,i have created a spreadsheet in MS Excel, and on one sheet, i have a list of students surnames (A2 - A36), and in cells B2 - B36 i have the list of first names.
In cells H2 - H36, i have a list of their email addresses.
What i want to do is that in sheet2, i want to be able to type in a students name, and have the email address come up.
The only other problem is that some students have the same surnames, like "Smith", so, i would want all the "Smiths" email addresses to be displayed.
I need to use VLOOKUP in the formula, but have no idea on what to type in!
I hope someone can help me, thanks!