Conditional cell values

**adam.sellers** · 03-03-2009, 12:28 AM

I am working on a sheet to deliver to some of our trading partners that needs an id number attached to the first column of the sheet. I have tried the formula =if(isblank(A2),"",<ID#>) to input the ID# (a hard coded numeric value, eg 56) into this first cell when the cell next to it is updated. However this inserts, by default, a NULL value into all 65K rows in the sheet as i need to copy and paste it down etc. Is there a way that i can get this value into the cell automatically when a value is entered (or pasted) into the A2 cell? I need to do this and not add any additional blank rows to the spreadsheet as this crashes an import downstream in the logic...

**Freaky_zoid** · 03-05-2009, 09:08 AM

Adam, what is wrong with your formula?
if it extracts the ID, and you don't know how many rows you're gonna have when the data is imported, you can only get the result by entring a formula (or a name).
maybe there is a way to use a macro, which I don't know well

**adam.sellers** · 03-05-2009, 05:37 PM

Mr Zoid

Thanks for you help with this one.. the problem with the formula is that i'm importing this spreadsheet into another application. When the import runs with this formula, the entire 65K are imported, mostly as null values... I've 'kind of' got around this problem by adding a custom value for the cell which only allows 1 number to be entered... but i can't set that cell as mandatory based on data in the cell next to it....

**Freaky_zoid** · 03-06-2009, 09:29 AM

Adam,
it is difficult to figure out the reason, 'cos I don't know anything about the other program you are using. But it seems to me that the problem is in not recognizing the links in excel formulae.
PS: actually I am miss Zoid, not mr