LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default lookup multiples

Help please

I need to bring information from one sheet to another based on 2 criteria to
make a report

For example on the data page

joe 1 5 15 20
sam 2 6 8 20
fred 1 3 15 20

If I am looking for 15 20 I need to bring joe and fred and all their
information with them into a sheet to generate a report. the report needs to
lists each person and do some calculations.

There could be 0 to 500 entries that meet the criteria. (the data sheet is
set up to hold a max of 500 entries

thanks

 
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
Calculating multiples of a number Excel Novice Excel Worksheet Functions 5 November 26th 06 10:20 PM
Multiples of 4 in an IF statement Barry Clark Excel Worksheet Functions 3 August 22nd 06 01:22 PM
rounding to multiples in excel ? HR gal Excel Worksheet Functions 0 August 8th 06 07:38 PM
matching multiples fields in 1 row Hobochunk Excel Worksheet Functions 0 November 28th 05 06:30 PM
Replace multiples from a list James Excel Discussion (Misc queries) 1 May 22nd 05 12:38 AM


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

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

About Us

"It's about Microsoft Excel"