I need to link up 2 sheet and they should update auto.Tried =sheet2!a3 but did not work tried =Vlookup(b2,sheet2!B2:c22 false) did not work.


Example.
Information in sheet 1 is the same in sheet 2 has date,number etc,If I update cell A4 in sheet1 Sheet2 A5 must be updated.I will use sheet 2 information and will not change.But sheet 2 will be like a database where different members will be entered.here is example of a spreadsheet.

Quote:

---

Originally Posted by tshidi

I need to link up 2 sheet and they should update auto.Tried =sheet2!a3 but did not work tried =Vlookup(b2,sheet2!B2:c22 false) did not work.

---

Both of those functions work for me just fine, though your second example is slightly formatted wrong.

=Vlookup(b2,sheet2!B2:c22 false) "false" doesn't belong in that formula, there should be a number there. VLOOKUP is used to find data in one column and report back info from the same ROW but in a different column. For instance:

COL 1 COL2
bird seeds
cat mouse
dog bone
ferret snake
hamster straw

If those are the cells from A1 through B5 on sheet 2, and you were searching for "dog", the formula would be:

=Vlookup(dog,sheet2!a1:b5,2)

That '2' at the end means show the info in the second column of the array when you find "dog" in the first column.

meanwhile, your first straight reference works just fine for me.