Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding Impasse
I'm trying to map a set of numbers to an indexed chart. Col A is a formula (eg. (=VLOOKUP($DF6,$O$3:$P$9000,2,TRUE)), producing a value generated from a lookup in an external array of cells(not shown).
First, the unique values of column A are mapped as headings to Col's F,G, etc. Then, the corresponding values are added below the headings. (I use this for creating values for a ComboBox) Col A B F G H _________________ _____________________ 1 A TYU A B C 2 A XXX TYU PTY YYY 3 B PTY XXX ZZZ 4 C YYY QQQ 5 C ZZZ 6 C QQQ It works well with text values, but doesn't work at all for numbers. The chart is blank, as shown below. Col A B F G H _________________ _____________________ 1 1 TYU 1 2 3 2 1 XXX 3 2 PTY 4 3 YYY 5 3 ZZZ 6 3 QQQ If I query the data by using the following formula in a blank cell... =IF(A1=F1,B1,""), I get nothing. I'm sure that it's a problem based on fundamentals, but I'm stuck! Any Ideas?? Jim Berglund |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding Impasse
I was able to fix this, but I still don't know why it wasn't working...
Jim "Jim Berglund" wrote in message news:s17ld.205299$nl.109443@pd7tw3no... I'm trying to map a set of numbers to an indexed chart. Col A is a formula (eg. (=VLOOKUP($DF6,$O$3:$P$9000,2,TRUE)), producing a value generated from a lookup in an external array of cells(not shown). First, the unique values of column A are mapped as headings to Col's F,G, etc. Then, the corresponding values are added below the headings. (I use this for creating values for a ComboBox) Col A B F G H _________________ _____________________ 1 A TYU A B C 2 A XXX TYU PTY YYY 3 B PTY XXX ZZZ 4 C YYY QQQ 5 C ZZZ 6 C QQQ It works well with text values, but doesn't work at all for numbers. The chart is blank, as shown below. Col A B F G H _________________ _____________________ 1 1 TYU 1 2 3 2 1 XXX 3 2 PTY 4 3 YYY 5 3 ZZZ 6 3 QQQ If I query the data by using the following formula in a blank cell... =IF(A1=F1,B1,""), I get nothing. I'm sure that it's a problem based on fundamentals, but I'm stuck! Any Ideas?? Jim Berglund |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum by coding | New Users to Excel | |||
How to fix the coding? | Excel Worksheet Functions | |||
Coding | Excel Discussion (Misc queries) | |||
"=ROW()-1" type of coding doesn't appear in a filter / is there coding that does? | Excel Programming | |||
API coding | Excel Programming |