Linked sheets and sorting

[justme]

I have a workbook which has linking between two sheets. I just determined this morning that when I sort the first sheet the link does not follow on the second sheet. The calculations are set to automatic. The link style is just ='First sheet name!K7.

I was thinking it would follow the line when it sorted. The first sheet has the ability to sort by multiple columns, so I really need the link on the second sheet to be dynamic.

 

[justme]

ok, linking may not be the way to go. Vlookup should work right? Tried this and I get a #N/A error.

=VLOOKUP(A7,'Sheet1'!A7:K150,11,2)

Where I want the value in A7 on sheet 2 to match the lookup on Sheet1, and then return the value in column 11 on Sheet1. What is my error?

 

[justme]

If you are following this post, I found my error, formula should be:

=VLOOKUP(A7,'Sheet1'!A7:K150,11,0)