We update inventory files and upload them in csv format to our customers. Currently we are updating 18 spreadsheets. I am creating a workbook where you enter the values in the first spreadsheet and it updates all of the subsequent spreadsheets. The problem is when I try to copy the individual spreadsheets it can't find the lookup. Is there any way to turn the lookup value into a number instead of a lookup?
Thank you,
Aline
The value you are looking up is text? if you want to turn it into a number you may get away with just adding +0 to the value, e.g.
A1 is "13" (text)
VLOOKUP(A13...) may result in #VALUE error as the range is numbers.
VLOOKUP(A13+0...) should cure this.
Probably need a more detailed description of the problem and maybe a desensitised sample workbook.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Do you want to fix the values instead of having the formula? If so, you can select all the cells with a formula in, then click on < copy >, then right-click and choose Paste Special | Values | OK then press the < Esc > key.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks