Indexing Issues

I have a workbook with 2 worksheet. On one we calculate the price for various kitchen layouts, we'll call it DATA. The second is basically a compacted Report of the data on the first. I have been using the Index() function paired with Match() so I only have to copy the Price per unit to the Report sheet. About five other value are pull across with Index() function and they are all on the same row on the data sheet.
The issue is when I have Price values that are the same, the index() of course pulls the first one, which may not be correct.
The Price Value I am coping from the DATA sheet has the correct row number for the other items, but how do I reference this row in my Index() or is there another function that will index to data with a know row and a column number?

A sample of your workbook would help.

Here is a sample

Any Ideas? Anyone?

The second argument in Index() is the row number how are you using index with out giving it a row? You can pass Index() rows and columns if you know where it is I don't see the problem.

The problem is the row number using the Match() function. The Match () returns the first match it finds in the array, so if i have 2 prices that are the same(value I'm searching for) Match returns the first, which might not be the value I need. Is there a way to reference the row in Column H on the takeoff sheet? This is the value(Price) from the Kitchenette sheet and contains all the value I need to copy. I guess the other approach would be a dynamic array of some sort.

Yes you can, Index(Table,Row,Column) You can use Match() again to give the correct column.

OK, But can I reference the row from the H column in the Takeoff Sheet? the cell H9 on the Takeoff sheet contains the "= Kitchenttes!L28", the row I want to reference is Kichenette!28. Is there a way to reference this row with a function from Takeoff Sheet? The rows on Takeoff sheet are copied and inserted depending on the size of the project.

You can use =address() to get the text and then delete the L

I'm missing something here. How do I get Address() to return a text reference for the link in Takeoff Cell H9?

OK, You have lost me now, can you give an example?

I does not return the wrong "Price" because "Price" is the Look Up Value. The issue is when two units have the same price, but different Quantities or Notes. Match() chooses the first which may or may not be the correct row number in this case.

I see what you mean, I think I can make it work.
Thanks