Make a new formula how automaticly change ordinary numbers into manipulated numbers.

Copper Contributor

Hi!

I have a problem that I cant solve. Somthing is wrong, but I cant figuer it out! I would be very grateful if someone have the time and the knowledge to help me! Thank you for your help!/ Marit Poutamo

 

The formula goes like this; =INDEX(´Values´B4:B43(´Values´ C4,E3:F6,0),4)

Number index

4=4

3=0

2=-1

1=-2

1 Reply
Hi Marit

Can you give a bit more explanation if what you are trying to do and ideally post some screenshots or a sample file.

It's not clear from your description what you are trying to achieve with the formula?

Thanks

Wyn