I have two workbook and i managed to perform vlookup on both of them. However, i have issues with the formula not working when new record is added on both workbook. I tried using dynamic name range, offset and it works but my lecturer said that my formula was wrong and told that I only needed vlookup function. I was like surprised so I tried to google search but no dice. Is there a way to make vlookup works when new record is added without using any function other than vlookup? Thx.