When I attempt to do a vlookup for a member's id it doesn't work unless I go in the workbook where I am looking and hit F2 on the cell and the number changes from a left indent to a right indent and the vooliup works. I have 4000+ cells and would like a shortcut rather than hitting the f2 button on every cell. Thanks for your help.