Glossary entry (derived from question below)
German term or phrase:
wverweis / sverweis
English translation:
HLOOKUP / VLOOKUP
Added to glossary by
Michael Grunwald
Jul 3, 2006 09:49
18 yrs ago
1 viewer *
German term
wverweis / sverweis
German to English
Tech/Engineering
Computers: Software
Microsoft Excel
Two functions in Excel, apparently accessible via 'Insert' --> 'Function'
Proposed translations
(English)
3 +1 | HLOOKUP / VLOOKUP |
Cilian O'Tuama
![]() |
Proposed translations
+1
22 mins
Selected
HLOOKUP / VLOOKUP
HLOOKUP
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The H in HLOOKUP stands for "Horizontal."
VLOOKUP
Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
--
from the "Lookup & Reference" category under "Insert Function" in the English version of EXCEL 2003
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The H in HLOOKUP stands for "Horizontal."
VLOOKUP
Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
--
from the "Lookup & Reference" category under "Insert Function" in the English version of EXCEL 2003
4 KudoZ points awarded for this answer.
Comment: "Thanks a lot - was really at a loss there!"
Something went wrong...