Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brett
 
Posts: n/a
Default VLOOKUPS

I have data in the following format:

Name Date Amount
Johnson 6/1/06 $100
Johnson 6/6/06 $300
Johnson 6/13/06 $350
Smith 6/2/06 $450
Smith 6/5/06 $100
Jones 6/16/06 $225

Every month the amount of times the name shows up will be different as well
as the dates they used the money.

I have different sheets for each name but i need to pull the dates and
amounts into seperate columns being:

Date Amount

Any help is greatly appreciated!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookups error message wmjenner Excel Worksheet Functions 5 June 11th 06 07:19 AM
VLOOKUPS: Limits on # per sheet? Trey Excel Discussion (Misc queries) 2 March 16th 06 03:19 AM
what is the maximum number of vlookups in a given workbook that E. Bartman Excel Worksheet Functions 2 November 4th 05 04:49 PM
Vlookups Shaya M Excel Discussion (Misc queries) 3 May 27th 05 07:17 AM
Vlookups wmjenner Excel Worksheet Functions 2 November 23rd 04 10:39 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"