Hi all, am using the following

=LOOKUP(L2,{"A","C","I","P1","P3"},{189.95,289.95,49.95,99.95,199.95})

And it is working well. Where the result vector part is (189.95 etc) I would like to replace this will a value in another cell, Say A1

So if A1 was changed from 189.95 to 219.95 the lookup value would display 219.95.

Any ideas?