VLookup - Multiple Rows with Exact Matching Column 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a worksheet moving copying from Worksheet 1 to
Worksheet 2.

On worksheet 1 my data is sorted by column 1 in months but I have multiple
lines per month.

I am trying to copy those multiple lines to a second worksheet without
actually having to copy and paste.

What is the best formula to use to have all columns of multiple rows copied
over as they are typed?

Thanks!
 
I'm not sure I understand what you mean, but do have a look here:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to create a worksheet moving copying from Worksheet 1 to
| Worksheet 2.
|
| On worksheet 1 my data is sorted by column 1 in months but I have multiple
| lines per month.
|
| I am trying to copy those multiple lines to a second worksheet without
| actually having to copy and paste.
|
| What is the best formula to use to have all columns of multiple rows copied
| over as they are typed?
|
| Thanks!
 
Sorry maybe I didn't explain well enough I am creating a new worksheet. I am
trying to add multiple rows with the same value in column A. I am trying to
add the data from an existing book with multiple worksheets.

On my existing worksheets, in Column A, are the months that I pay an
invoice... (april, may, june, etc.)

On my new worksheet I would like to return each row on my old worksheets
that starts with for instance April.

I can use Vlookup but I can only return data from the first row that has
April. How do I also return data from the second row that has April as the
lookup_value?

Hope that helps a little....
 
Back
Top