+ Reply to Thread
Results 1 to 5 of 5

Hlookup with rows (an array)

  1. 10-30-2015, 03:14 AM #1
    [email protected]
    saba@thejaingroup.co is offline
    Registered User
    Join Date
    12-18-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    47

    Hlookup with rows (an array)

    Hi all,

    I have used Vlookup with columns (an array) and its working BUT the same does not work for Hlookup.?
    I have attached a file for reference.Please help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-30-2015, 03:21 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Hlookup with rows (an array)

    Try=HLOOKUP(B$7,$B$3:$E$5,{2;3},0) like this instead of =HLOOKUP(B$7,$B$3:$E$5,{2,3},0)
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 10-31-2015, 02:56 AM #3
    [email protected]
    saba@thejaingroup.co is offline
    Registered User
    Join Date
    12-18-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Hlookup with rows (an array)

    Thanks nflsales,but what does ";" instead of "," means.?How does it help.?
    Reply With QuoteRegister To Reply
  4. 10-31-2015, 03:47 AM #4
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: Hlookup with rows (an array)

    ";" indicates for rows and "," indicates for columns
    Reply With QuoteRegister To Reply
  5. 11-03-2015, 02:42 AM #5
    [email protected]
    saba@thejaingroup.co is offline
    Registered User
    Join Date
    12-18-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Hlookup with rows (an array)

    Thanks a ton nflsales.It is the far best excel forum I ever came across with experts beyond excellence.!
    Thanks again.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. hlookup and summing an array
    By pervina in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2014, 07:06 PM
  2. HLookup on Lookup Array
    By FTPS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2011, 02:43 PM
  3. Excel 2007 : Is it possible to return an array using hlookup?
    By adanglst in forum Excel General
    Replies: 5
    Last Post: 07-15-2010, 07:28 PM
  4. HLOOKUP and array formulas #N/A
    By rpadrela in forum Excel General
    Replies: 5
    Last Post: 01-02-2010, 08:56 AM
  5. Table Array within hlookup not working
    By mattted in forum Excel General
    Replies: 3
    Last Post: 03-03-2009, 07:09 PM
  6. HLOOKUP without any fixed array
    By leongkeat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2008, 03:32 AM
  7. HLookup? or an array function??
    By Murph in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1