Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chris
 
Posts: n/a
Default Formula for Searching & matching two values in excel

Hello I wonder if anyone can help with my problem....

I need to create a lookup to match two values in one
worksheet with two values in another sheet, returning a
third value:

So I have two worksheets in excel Projects and Orders.
To match these sheets, the Orders page contains lots of
duplicate "Order Codes" which are numbered between 1 & 20
called "Line item". These Order line items each refer to a
particular Project on the Projects sheet but can only be
traced to a Project by searching the Projects sheet for
Order number then Line item. So for instance Order 1234
Line Item 1 refers to Project 1; Order 1234 Line Item 2
may refer to a different Project i.e. 2.

So I need to be able to create a formular on the Orders
page to search the Projects sheet for "Order Code" to find
all the orders, then find the matching "Line Item Number"
(1-10) returning the particular PROJECT number.

I have been trying to use vLookup and Index, but failing.

Can anyone help?

Thanks
Chris

  #2   Report Post  
maria ward
 
Posts: n/a
Default

Sounds Like you need to use SUMIF, instead of a lookup!



-----Original Message-----
Hello I wonder if anyone can help with my problem....

I need to create a lookup to match two values in one
worksheet with two values in another sheet, returning a
third value:

So I have two worksheets in excel Projects and Orders.
To match these sheets, the Orders page contains lots of
duplicate "Order Codes" which are numbered between 1 &

20
called "Line item". These Order line items each refer to

a
particular Project on the Projects sheet but can only be
traced to a Project by searching the Projects sheet for
Order number then Line item. So for instance Order 1234
Line Item 1 refers to Project 1; Order 1234 Line Item 2
may refer to a different Project i.e. 2.

So I need to be able to create a formular on the Orders
page to search the Projects sheet for "Order Code" to

find
all the orders, then find the matching "Line Item

Number"
(1-10) returning the particular PROJECT number.

I have been trying to use vLookup and Index, but

failing.

Can anyone help?

Thanks
Chris

.

Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Missing values in Excel Line Chart mw55309 Charts and Charting in Excel 1 January 19th 05 01:10 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 04:38 AM
Using excel to select only matching images... davidbev008 Excel Discussion (Misc queries) 1 December 3rd 04 08:18 PM
Preserve Excel formula entry MHoffmeier Excel Discussion (Misc queries) 5 December 2nd 04 07:34 PM


All times are GMT +1. The time now is 10:49 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"