Share via

how to extract multiple values for same reference using Vlookup or by any other method in excel?

Anonymous
2023-03-22T00:01:31+00:00

Hi,

I need all the items on right side for the same reference on the left side, whereas for me i am getting only the 1st item on right,

kindly help me sorting this out.

Regards,

santho

An example FYR.

BSS-901-PIP4401-014-080-CSP1-HC SIV-A201103-BSS-901-4401-014-01
BSS-901-PIP4401-014-080-CSP1-HC SIV-A201103-BSS-901-4401-014-03
BSS-901-PIP4401-014-080-CSP1-HC SIV-PR2003-BSS-901-4401-014-01
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,885 Reputation points Volunteer Moderator
    2023-03-22T07:00:05+00:00

    I mean the FILTER function that you use in formulas. For example:

    =FILTER(B1:B1000,A1:A1000=C1)

    will return all rows in B1:B1000 where the value n column A equals what is in C1

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-03-22T00:41:48+00:00

    Hi,

    i am using Microsoft Office home & business 2021,

    & i have filter option, but i intend to vlookup because i have lookup value on another sheet.

    Thanks,

    Santho

    Was this answer helpful?

    0 comments
  3. Rory Archibald 18,885 Reputation points Volunteer Moderator
    2023-03-22T00:12:46+00:00

    Which version of Excel do you have? Do you have the FILTER function available?

    Was this answer helpful?

    0 comments