change through vlookup found value back in mastertable.

Hello everybody,

Im currently challenged by a little problem in excel which i hope to be able to solve with your help.

I build kind of an interface in on excel worksheet which depending on Produkt-Nummer shows via lookup Price, Amount sold and so on.

This works perfectly. However now the challange is that my boss would love to be able to change lets say the through vlookup shown price and so overright the value in the mastertabel. So that next time he plugs in the Produktnummer he new value is shown.

This is the most basic form of the problem as u gone see in the formula below the problem is even more complicated since depending on another cell value where the user can wright a 1 or 2 the tabbel where the data is pulled from is different. Also does the problem not only apply to the price in my interface but i have 6 cells which he would like to be able to change so they get changed in the mastertabel. The dataset is around 10000 entrances.

The formula currently showing the price is:


=(IF(AND(D3<>0;D10=1);VLOOKUP(D3;'Kost 1 number'!A:L;5;FALSE);IF(AND(D3<>0;D10=2);VLOOKUP(D3;'Kost 2 number '!A:L;5;FALSE);IF(AND(D5<>0;D10=1;D3=0);VLOOKUP(D5;'Kost 1 number'!B:L;4;FALSE);IF(AND(D3=0;D5<>0;D10=2);VLOOKUP(D5;'Kost 2 number '!B:L;4;FALSE))))))

It depends on storage 1 or 2 and if the person put in produktnumer or Produktname.

Hope anyone can maybe help me.

With kind regards,

hbr1