Can Vlookup retrieve a range of cells from source to target sheet or any other fx

  • Thread starter Thread starter sayvari
  • Start date Start date
S

sayvari

Hi!

I have several sheets of Debtors Ledger for each year, I am using the
FileNo.(or Account No.)as the unique identifier which is a common
feature in all the sheets.

Now, in each sheet for the same FileNo. there are several transactions.
Vlookup returns values for the first instance of the Unique
identier(FileNo.) it comes across, but I need on the target sheet all
instances of transactions occuring with respect to that File no..

How do I get over this hurdle?

Any ideas!

Sayvari
 
Have you tried to use "Autofilter"?
It would do exactly what you're looking for.

If you really wish to use a formula to return multiple instances of an item
I.D., this can be accomplished with an arrayed Index function.

If you're interested in this type of solution, post back with a brief
description of the configuration of your list.
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi!

I have several sheets of Debtors Ledger for each year, I am using the
FileNo.(or Account No.)as the unique identifier which is a common
feature in all the sheets.

Now, in each sheet for the same FileNo. there are several transactions.
Vlookup returns values for the first instance of the Unique
identier(FileNo.) it comes across, but I need on the target sheet all
instances of transactions occuring with respect to that File no..

How do I get over this hurdle?

Any ideas!

Sayvari
 
Back
Top