I thought that would be the case. Guess Ill add another non-INDEX line on
the quote sheet.

thank you,

"Frank Kabel" wrote:

Hi
no this is not possible. You can't have a formula and a manual entered value
in the same cell

--
Regards
Frank Kabel
Frankfurt, Germany

chris w wrote:
I have an INDEX look up an item and put in a corosponding price. I
would like to have one item in the lookup to be able to have the user
input a price without wiping out the formula. Is it possible?
example
A-------B
shoe---5
sock---3
smell--allow input