It is one of the requirements that I use a vlookup table in my spreadsheet. i've collected background of 50 people's penchant gaming platforms (e.g. PS 3, PC, X BOX) as okay as the time spent on it, time spent on adjectives different platforms and masculinity (25 girls, 25 guys).
I requirement suggestions for anything that I could put on my spreadsheet lacking getting anymore information which uses the vlookup function. Thx ;)
Answers: You can hold an nouns contained by your spreadsheet where on earth somebody enter a dub, and you use the VLOOKUP formula to compress surrounded by their masculinity, favorite system, etc. from your spreadsheet.
Let's speak your notes is surrounded by A1:F50, and you type surrounded by a cross to look up contained by G1.
If the name are contained by column A, and sexual characteristics is within column B, and you want to look that up and put it contained by H1, you would own this:
=VLOOKUP(G1, $A$1:$F$50, 2, FALSE)
The 2 technique the formula will show what's within the 2nd column of the list (i.e. B).
You can also trade name the entry contained by G1 be a drop down roll of adjectives the name surrounded by column A:
- walk to G1
- Data - Validation - Settings tab
- Allow: List
- Source: =A1:A50
If you requirement more info, add on more details or e-mail.
Cheers.
.
Show the being next to the most time spent.
Assuming the time spent is in column A and the peoples name are within column D your formula would be:
=VLOOKUP( MAX(A1:A50) , A1:D50 , 4 , specious )