Double in Excel formula

January 28, 2013 at 04:03:44
Specs: Windows XP
We have listed some iten in cell A4 and said it as <.99 mn to 1million, (1m to 1.5 mn), (1.5 to 2 mn) then in cell A3 we have some values 3(<9.99mn to 1 mn),4(1mn to1.5mn),likewise5,6 & 7.
I want to seletc one value from the list in A1(<9.99mn to 1mn) and in A2 want to see the corresponding value as 3. Please let me know how to go about it.

See More: Double in Excel formula

Report •

January 28, 2013 at 12:43:47

It's not clear how your data is arranged. Could you post a sample using the instructions in this link.

In the meantime response #2 in this link might be what you're looking for

Report •
Related Solutions

Ask Question