S
sonar
Hi,
I have 13 digits in my barcode numbers, and I can only have their cell
format in either TEXT, or NUMBER format.
_______________________________________________________________
The thing is, I can't type it in cells that is in a Number format, if
I do, my description column in '13DBC'!$B10 using
=IF(A10<>0,(VLOOKUP($A10,'Stock Items'!$A$3:$B$1002,2,FALSE)),"")
gives me a #N/A and does not give me my description.
But it works if I have my cell Format in TEXT format.
_______________________________________________________________
The problem now is, is that I want to pass the information from 13DBC
to SHORT-1, with the formula
{=IF(ROWS($1:1)<=COUNT('13DBC'!$V$10:$V$999),INDEX('13DBC'!A$10:A$999,
SMALL(IF('13DBC'!$V$10:$V$999<>"",ROW(INDIRECT("1:"&COUNT('13DBC'!$A$10:$A$999)))),ROW(1:1))),"")}
but cant, because my cells are in text format in 13DBC column A.
_______________________________________________________________
In my 'Stock Item' Sheet the cell format (column A) is Number format,
and I am using this formula
=IF($A455<>"",IF(ISERROR(VLOOKUP($A455,Mo!$A$1:$X$1000,4,FALSE)),"",VLOOKUP($A455,Mo!$A$1:$X1452,4,FALSE)))
to extract unit prices, it works for the 3 to 8 digit barcodes
(numbers), but not for the 13 digit barcodes (numbers)
_______________________________________________________________
Any idea how I can fix this? Is there a cell format that I can use,
that will not trow the 13 digit numbers in a Scientific format
(2.90688E+12) and that will work with all formulas?. Something I can
use accross the board. e.g my 3 to 8 digits as well.
Regards
Antoinette
I have 13 digits in my barcode numbers, and I can only have their cell
format in either TEXT, or NUMBER format.
_______________________________________________________________
The thing is, I can't type it in cells that is in a Number format, if
I do, my description column in '13DBC'!$B10 using
=IF(A10<>0,(VLOOKUP($A10,'Stock Items'!$A$3:$B$1002,2,FALSE)),"")
gives me a #N/A and does not give me my description.
But it works if I have my cell Format in TEXT format.
_______________________________________________________________
The problem now is, is that I want to pass the information from 13DBC
to SHORT-1, with the formula
{=IF(ROWS($1:1)<=COUNT('13DBC'!$V$10:$V$999),INDEX('13DBC'!A$10:A$999,
SMALL(IF('13DBC'!$V$10:$V$999<>"",ROW(INDIRECT("1:"&COUNT('13DBC'!$A$10:$A$999)))),ROW(1:1))),"")}
but cant, because my cells are in text format in 13DBC column A.
_______________________________________________________________
In my 'Stock Item' Sheet the cell format (column A) is Number format,
and I am using this formula
=IF($A455<>"",IF(ISERROR(VLOOKUP($A455,Mo!$A$1:$X$1000,4,FALSE)),"",VLOOKUP($A455,Mo!$A$1:$X1452,4,FALSE)))
to extract unit prices, it works for the 3 to 8 digit barcodes
(numbers), but not for the 13 digit barcodes (numbers)
_______________________________________________________________
Any idea how I can fix this? Is there a cell format that I can use,
that will not trow the 13 digit numbers in a Scientific format
(2.90688E+12) and that will work with all formulas?. Something I can
use accross the board. e.g my 3 to 8 digits as well.
Regards
Antoinette