Thread: VBA Vlookup Variable Sheet Reference

Hi All, I'm trying to set up a vlookup function to reference a varying sheet Name. Basically, there are two sheets that go together a summary and a review sheet. The sheets are all named "xxxxx Summary" and "xxxxx Review" This Macro will be run on the review sheet, but I need to look up information off the summary sheet. So I was thinking the following to get the sheet name, which works fine. CustomerSummary =...

Hello You forgot the ' in the formula: Code: "=Vlookup(A3,'" & CustomerSummary & "'!$A$3:$B$65536,2,0)" (after the first comma and in front of the double quote ". I also had to add a space in front of "Summary" in: Code: CustomerSummary = Left(ActiveSheet.Name, Len(ActiveSheet.Name) - 7) & "Summary" By the way, do you really need such long ranges in your...