Hi everybody,
I wan to no about Vlookup and Hlookup in MS Excel. How it does work?
Please tell with briefly and with example.
2007-08-05 20:44:07 · 5 answers · asked by Anonymous in Computers & Internet ➔ Software
How about a simple search?
2007-08-05 20:53:23 · answer #1 · answered by enigmatech13 2 · 0⤊ 0⤋
1
2017-01-20 20:27:12 · answer #2 · answered by ? 4 · 0⤊ 0⤋
Lookup will do what its name implies. It will look up a value in a cell in your worksheet - it looks in a array that has usually been entered for this purpose. Lookup will return a value from the array that is related to the value you are looking up.
For example, on an invoice form. You type a part # in one cell and Excel finds the price in the lookup table and places it in the cell.
Read the reference material from first answer links.
2007-08-06 00:49:04 · answer #3 · answered by vbmica 7 · 0⤊ 0⤋
Youtube got plenty of tutorial. You just need to search on Youtube. But I don't sure any tutorial about Excel 2000 is exist because it is almost very old version of MS Office Suite.
2016-03-16 07:39:50 · answer #4 · answered by Anonymous · 0⤊ 0⤋
The purpose of vlookup and hlookup is to find out if you've got the correct information in your source document. So it involves matching a long list with another long list.
Vlookup is for lists that extend vertically. Hlookup is for lists that extend horizontally.
In a blank column right next to your first list, you would type: "=vlookup(column with first list, columns with first list and second list, number corresponding to the amount of columns between the first and second list, false)"
In the above example, you will want to highlight the whole column.
2007-08-05 21:08:44 · answer #5 · answered by Beth Rorie 3 · 0⤊ 1⤋