How to use the "PROCH" function of Excel to search values from the bottom up?

0

By default the "Proch" function searches only the top-down values, I want to do the reverse, search the values from the bottom up, I want to search for the "40-D" character by reference "Cod.prod", how do I proceed through the "Proch" function ?? or is there another function that performs this procedure ??

    
asked by anonymous 23.11.2018 / 16:38

2 answers

1

@Elienay by picking up the table you present and always have the value above Cod.prod uses the following formula in cell G44 .

=+DESLOCAMENTO(B48;-1;CORRESP(F44;C48;0);1;1)  

EDITION

As you can see the formula has been developed according to your initial table.

Table:

Table :

    
05.12.2018 / 10:20
1

This is not possible because the logic of PROCH is from top to bottom, just as PROCV is from left to right, always from the first line, to the PROCH, or first column, to PROCV.

One solution to your case is the use of INDEX + CORRESP

But if it's worth a comment, it does not make sense to work that way with the column names below. I suggest standardizing the table instead of following it this way.

    
29.11.2018 / 14:10