Copy documents from one table onto another page

Hello,

i want to copy information out of a table. The problem is that that the row i am searching in is a row higher than the result i am looking for. So vlookup is not working. Is there a way to let excel search in another column one row lower ? Thank you for ur help.

Best regards

Costa

Use INDEX/MATCH instead of VLOOKUP, and then you can add 1 to the MATCH element of the formula.

If you need further guidence then attach a sample Excel workbook - see the yellow banner at the top of the screen for details of how to do this.

Pete

The problem is that the table is always changing size depending on the process. In my example i have Melting and Dying and i need to find the kind of energy they use.
In the example Gas and electricity. The problem is that there are different manufactioring steps, so the position is always changing and i want to just upload the different tables in the excel sheet, and get the ansers on the other page.
is that possible ?

Best Regards,

Costa

You can use this formula in cell H6 in the solution sheet:

=IFERROR(INDEX(Table!$F:$F,MATCH(E6,Table!$A:$A,0)+1),"not found")

Hope this helps.

Pete

EDIT: By the way, you will probably have to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Pete

It worked. Thank you very much.

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete