xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:24 PM.
1st, pretty much none of your numbers are actually numbers/values, they are text that just looks like a number (just try adding 1 to them, in another cells). You will need to convert them/make them numbers
2nd, you cannot compare numbers (even after you have converted the text to numbers) to text - which is what you have on sheet2....<1
Where is this data coming from?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
xxxxxxxxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:23 PM.
Lets take this in stages...
1. make sure that all your headings match (eg make "Big Bold Red" = "Sea Big Bold Red")
2. are all your tests being done with the ranges in sheet2? (eg 60-120...38-43 etc) Again, this is text, and would need to somehow be converted to 2 seperate numbers for the comparison
This is what I have so far...
to find the value from sheet2...
=INDEX(SPECIFICATION!$B$7:$E$39,MATCH(PRODUCTS!C$9,SPECIFICATION!$A$7:$A$39,0),MATCH(PRODUCTS!$B10,SPECIFICATION!$B$6:$E$6,0))
(this is returning <1)
To convert the "number" in sheet1 to a real number...
=--SUBSTITUTE(C10,",",".")
Here is where I am trying to head.
lets say that Spec sheet A16 was DO, instead of A17, then to do the CF, I would use this formula...
=INDEX(SPECIFICATION!$B$7:$E$39,MATCH(PRODUCTS!C$9,SPECIFICATION!$A$7:$A$39,0),MATCH(PRODUCTS!$B10,SPECIFICATION!$B$6:$E$6,0))<--SUBSTITUTE(C10,",",".")
xxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:20 PM.
yes, I got that2. Yes SPECIFICATION sheet is the reference ranges for the test.
What I meant was - are you testing (where applicable) against cells containg ranges like 60-120 or 38-43. As I said, these are text entries. Would it be possible to split those into 2 seperate cells/columns? In other words, each category in the Spec sheet will have 2 columns
xxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:20 PM.
xxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:20 PM.
xxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:20 PM.
xxxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:23 PM.
xxxxxxxxxxx
Last edited by James__S; 08-24-2015 at 06:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks