Results 1 to 3 of 3

Thread: vlookup multiple values

  1. #1

    vlookup multiple values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Please look at my attachment. I am desparate to get this formula. In column C I need values from Q matching B (location). Please help.
    Attached Files Attached Files
    Last edited by midra; 2013-08-10 at 12:43 AM.

  2. #2
    Try this array formula

    =IFERROR(INDEX($Q$2:$Q$14,SMALL(IF($P$2:$P$14=$B3,ROW($P$2:$P$14)),COUNTIF($B$3:$B3,$B3))-1),"EMPTY LOCATION")

  3. #3

    Smile

    Quote Originally Posted by Bob Phillips View Post
    Try this array formula

    =IFERROR(INDEX($Q$2:$Q$14,SMALL(IF($P$2:$P$14=$B3,ROW($P$2:$P$14)),COUNTIF($B$3:$B3,$B3))-1),"EMPTY LOCATION")





    You are a genius. Thank you

Posting Permissions

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