what or how do you enter the formula vlookup to search in excel?.
2007-05-14 17:27:53 · 2 answers · asked by espei1 1 in Computers & Internet ➔ Software
It's difficult to explain, so I suggest using the function wizard (it looks like 'fx' on your toolbar). Then go to the "lookup & reference" and select VLOOKUP.
In the first field, you want to select the first cell that has the data in common for both fields in the VLOOKUP (example: if you want to find dates of birth based on names, where one sheet has a name, and the second has names & dates of birth, then you'd select the upper-leftmost name from the sheet that has only names).
The second field defines the range that you want to find the information in. (This would be the column with names through the column with DOB's)
In the third field of the formula wizard, you enter the column # you want to return from the range you selected. If you selected 10 columns, and the DOB's are in the 10th, then type in 10.
The fourth field, I always enter 0, but I don't know why (except to say that it doesn't work any other way for me).
2007-05-14 17:34:26 · answer #1 · answered by Mickey Mouse Spears 7 · 0⤊ 0⤋
=vlookup(Cell to lookup, range to lookup in, column of data to return when found, absolute match or not)
=vlookup(A2,B2:H15,2,0) zero meaning absolute match
2007-05-14 17:32:30 · answer #2 · answered by Lord L 4 · 0⤊ 0⤋