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!


    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.


  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Excel Version
    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