Help on HLook up
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Help on HLook up

  1. #11
    New Member
    Join Date
    Aug 2009
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Help on HLook up

    Perfecto Peter... it worked fine.. Thanks a zillion for all your help. Have a great day ahead.. Cheers...

    Quote Originally Posted by Peter_SSs View Post
    You are on the right track but there are 3 issues
    1. You need a $ sign in from of B3 to lock that to column B when you drag across.
    2. You have a comma where you should have an = sign
    3. You have the ,"" near the end in the wrong place

    Try
    {=IF($B3="Active",LOOKUP("Z",IF($C$2:$V$2=Y$2,$C3:$V3)),"")}

  2. #12
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    40,469
    Post Thanks / Like
    Mentioned
    86 Post(s)
    Tagged
    19 Thread(s)

    Default Re: Help on HLook up

    Quote Originally Posted by tinferns View Post
    Perfecto Peter... it worked fine.. Thanks a zillion for all your help. Have a great day ahead.. Cheers...
    Glad to help. .. and thanks.
    Hope this helps, good luck.
    Peter
    Excel 365 - Windows 10
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules, Forum Use Guidelines, & FAQ

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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