Lookup function with different cell references

**Nett** · 07-13-2009, 09:06 PM

Does anyone know if it's possible to use the lookup funtions if I have 2 worksheets in the same spreadsheet with the same template but different cell referencing. Thanks.

**Palmetto** · 07-13-2009, 09:10 PM

You should probably be more specific about how you want to use the look up function, but the answer is yes, as long as you specify the correct sheet/cell references.

**Nett** · 07-13-2009, 09:46 PM

Hey there, thanks alot for the prompt reply.=)
Ive attached a TEST attachment as an example. Im actually trying to use the lookup function to copy the values in Sheet 2 to the Master page such that when i make amendments to the values in Sheet 2 it will change the values in the master page as well. Im not sure if vlookup is the right function to use.

**Nett** · 07-13-2009, 10:01 PM

I tried using macro and the values can be transferred to the Master page perfectly but when amendments are made in Sheet 2, the values in the Master page does not change at all. Since the cell references of both templates are different, I'm not able to use the vlookup ='Master' . Anyone know how i can use vlookup function to achieve this. I would really appreciate if anyone can help or advice me in this. Thanks.