is it possible to lock-link cells?

[petit.miette]

I am working on a spreadsheet for a fund raising dinner. I have one
worksheet that lists all guests, including hosts, table#, and seat#. Then, I
have a series of other "donation tally" worksheets...one per table...that
autofills host, guest, table#, and seat# based on the comprehensive
worksheet. Right now, they are connected by cell location (i.e. Guests!B42).


The problem is this...when the comprehensive worksheet is sorted or an extra
"seat" is added...the tally sheets become incorrectly populated.

Is there a way to lock-link cells, so that they are forever connected
regardless of sorting or inserting additional rows?

 

[Eduardo]

Hi,
Use Vlookup function
=+VLOOKUP(A3,Sheet2!A,2,FALSE)
Where Sheet2 columns A and B is where you have your information , in Sheet 1
cell A3 is where you enter the name and 2 means the column where you retrive
the information
If this was helpful please say yes, thank

 

[petit.miette]

You are a genius! Thank you so much!!

Hi,
Use Vlookup function
=+VLOOKUP(A3,Sheet2!A,2,FALSE)
Where Sheet2 columns A and B is where you have your information , in Sheet 1
cell A3 is where you enter the name and 2 means the column where you retrive
the information
If this was helpful please say yes, thank