Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HLookUp Function
Hi all
I often use VLookUp tables, however, I've never used HLookUp. Is the only difference between them the way the data in the table is displayed - either in columns or rows? Thank you. Louise |
#2
|
|||
|
|||
Yes
-- Regards, Peo Sjoblom "Louise" wrote in message ... Hi all I often use VLookUp tables, however, I've never used HLookUp. Is the only difference between them the way the data in the table is displayed - either in columns or rows? Thank you. Louise |
#3
|
|||
|
|||
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." charlie "Louise" wrote in message ... Hi all I often use VLookUp tables, however, I've never used HLookUp. Is the only difference between them the way the data in the table is displayed - either in columns or rows? Thank you. Louise |
#4
|
|||
|
|||
Hi Louise,
In a nutshell - yes. Instead of spanning down a set of columns to conduct a lookup, it looks across a set of rows. Instead of referencing using a column index number it uses a row index number. Cheers, Jon "Louise" wrote: Hi all I often use VLookUp tables, however, I've never used HLookUp. Is the only difference between them the way the data in the table is displayed - either in columns or rows? Thank you. Louise |
#5
|
|||
|
|||
Thank you all. I thought as much but just wanted to check.
"Charles Woll" wrote: 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." charlie "Louise" wrote in message ... Hi all I often use VLookUp tables, however, I've never used HLookUp. Is the only difference between them the way the data in the table is displayed - either in columns or rows? Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions |