multiple lookups help

b19upj

New member
Joined
Mar 31, 2015
Messages
8
Reaction score
0
Points
0
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
 
Hi,
can u attach excel file. i.e, sample data.
 
Back
Top