adjusting formula index with count t get last value in column

[ABDELFATTA]

hello

i need help to fix my formula to get the last value in columns it supposes the result in e2,e3,d2,d3 after search in cell a3
this is my formula

[Pepe Le Mokko]

In D3 enter

Please Login or Register  to view this content.

and pull right

[ABDELFATTA]

hi, pepe you can check my file after use a new formula , your formula works only in e2 and 2 and gives me wrong date in e3,d3 and i would for you make clear this

what means , please ?

[Pepe Le Mokko]

See attached
Use the Evaluate formula tool to see how the formula works

[ABDELFATTA]

where i get this tool from,please ?

[Pepe Le Mokko]

Formula tab - Formula auditing group

[ABDELFATTA]

thank pepe for every thing now formula really works

[Pepe Le Mokko]

You're welcome
also see https://www.ablebits.com/office-addi...okup-function/ for more explanation