how could copy the value from E to F

[tomy_xx]

How could i search if value matches in column B , take a copy of next value in

column E and put it into another cell.

 

[tomy_xx]

after

 

[tomy_xx]

so the code take the second value instead of the first one

 

[tomy_xx]

the code take the yellow instead of the red so, i modify the condition to take the red firstly then the yellow after that each on in a separate cell like C30

 

[Joe4]

You don't really need VBA for that. You can use the formula described in this method here: Formulas to Vlookup Values from Bottom to Top in Excel 365!!

So the formula might look something like this:

=LOOKUP(2,1/(B1:B20="CPF1164"),C1:C20)

 

[tomy_xx]

You don't really need VBA for that. You can use the formula described in this method here: Formulas to Vlookup Values from Bottom to Top in Excel 365!!

So the formula might look something like this:

=LOOKUP(2,1/(B1:B20="CPF1164"),C1:C20)

same result

 

[Joe4]

same result

It worked on the example you posted up in post 21.

 

[tomy_xx]

It worked on the example you posted up in post 21.

 

[tomy_xx]

i think i will search google for solution ,, thank you for your efforts

 

[Joe4]

Not really sure what you are showing in your last post (it is not the same as your previous one).
It looks like you just repeated the same formula/line 3 times.

I think you are just having a really hard time communicating to us exactly what you are looking for.

 

[Joe4]

i think i will search google for solution ,, thank you for your efforts

OK, good luck.