Arthur Fuller
fuller.artful at gmail.com
Fri Aug 24 09:10:14 CDT 2007
Forgive the double-post. I wasn't sure whether this belongs on dba-Tech or if it's ok here. 1. When I change column widths on one sheet, it seems to change them on all sheets. Can't I affect only one sheet? 2. On one of my sheets there is a column that does a VLOOKUP() into another sheet. Except for the relative row number of the lookup value, the formulae are identical down the column. But two lookups fail. There doesn't seem to be anything different about these two. In one case the lookup value is 4431 and the other 11503. I tried switching them to strings and ditto in lookup table, to no avail. Any idea why these two, and only these two out of about 80 lookups, fail? TIA, Arthur