Results 1 to 2 of 2

Thread: multiple lookups help

  1. #1

    multiple lookups help



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

    Hi,

    I want to lookup a value in a column cell, but once it has found the value that im looking for in the second spreadsheet, i want it to look for further rows with that value in it. The vlookup i write stop when it matches the value ie when the criteria is met.
    But i have about 5 rows (5 numbers) which would match the vlookup value im trying to find from the first spreadsheet.
    How can i make a new column or row in the first spreadsheet for as many matching values as there is for each value being looked up from the first spreadsheet.

    TIA

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    can u attach excel file. i.e, sample data.

Tags for this Thread

Posting Permissions

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