Referencing cell on PLAN2 to a new expanded sorted cell on PLAN1. How ?

[gibrancurtiss]

Hi.

Thank you all for this incredible board. This is my first post.

How can I keep referenced cells on Planilha2 pointing to correct Planilha1!B column cells when do an expanded sort on Planilha1!A column?
Example : in the attached file you can see that

Planilha2
C2 = =A2*Planilha1!B1

If I do an extended sort on Planilha1!A column, all values on Planilha1!B will change the row position and the referencing cells on Planilha2 will be lost.

How can I keep them referenced ?

Thank you all!!!

[oeldere]

Use VLookup for that job.


sheet2

C2=VLOOKUP($B2,Planilha1!$A$1:$B$10,2,0)*A2


See the attached file.

[gibrancurtiss]

OMG ,

Thank you oeldere !

I?m strugling and searching 2 days with this.

Regards!

Gibran

[oeldere]

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation , to all members who helped you.

[gibrancurtiss]

both done !!

thank you!!!