Post Author: shreyasb
CA Forum: Xcelsius and Live Office
Hello,
I have a combo box including group numbers A, B,C. The way my spreadsheet is set up as below. I am trying to insert the source data for combo box into spread sheet cells C2 and D2. I have a cell E2 which has a formula: VLOOKUP(C2,C2:D2,2,False) which yields me a value every time I click on the combo box. Cell E2 is linked to a gauge in order to stop progress of needle. This logic when executed in 4.5 works fine. Doesnt in 2008. Have any body seen this behavior in 2008? Or am I missing something? .. Thanks
1 A B
2 A 10
3 B 20
4 C 30