Reply to thread

Message: [QUOTE="Sungibungi, post: 3263284"] Thanks for the solution Jacob. I really appreciate it. It had more to do with the way I referenced the file. I have an additional question for you, if you can help me. It seems like a simpler function but I can't get it to work. The scenario is basically the same as described before but referencing to another sheet (Ex. - Sep 09 Update), not another file. So this is the formular I came up with. =VLOOKUP($A1,INDIRECT(Z1&" Update!A:B"),2) It still gives me a #REF error. Is my sheet referencing off? Once again, thanks for your help. [/QUOTE]