LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Data Query using Match/Index

Every month my company outputs an excel file in the format (not that the
project number is only used once on a differnt row than everything else):

project Desc Amount
1.2.1
labor 10
material 5
other 15
1.2.X
labor 12
material 33
other 11

If, however, a project (using project 1.2.1 as an example) did not incur
material expenses then the report would look like:

project Desc Amount
1.2.1
labor 10
other 15
1.2.X
labor 12
material 33
other 11

I'd like to set up a query to find out the cost for a particular project and
a particular desc... for example, what were the labor costs for project
1.2.1. I can easily use match/index if the project number was on every row,
but since it is only on one row, I am stumped. Any help would be much
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
Index, match, multiple IFs query zx6roo Excel Worksheet Functions 9 May 8th 10 08:46 AM
if, Isnumber, Match, &index query Juls Excel Discussion (Misc queries) 0 October 23rd 06 02:07 AM
index and match query kate Excel Worksheet Functions 1 August 7th 06 12:59 AM
INDEX AND MATCH QUERY ? kate Excel Worksheet Functions 2 July 17th 06 01:19 PM
index,match,match on un-sorted data Brisbane Rob Excel Worksheet Functions 3 September 24th 05 10:04 PM


All times are GMT +1. The time now is 11:41 PM.

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"