Hi:

This formula is in (hidden column G )

=IF(ISNA(VLOOKUP
(A6,Material DataBase!$A$9:$H$100,2,0)),€�€�,
VLOOKUP(A6,Material DataBase!$A$9:$H$100,2,0))

This formula is in cell D

=IF(A6 ="","",B6*C6*G6)

A B C D E F G

Item Cost Amount Total

Nails 0.25 10 2.50
Bolts 1.00 8 8.00

A listbox is populated from column A of the
€œMaterial Database€� Worksheet (more of a list)

The user can pick items from the list and as
oblivious from cell Gs formula the price
is then in G and the routine is complete.

All works as expected:
The user can copy, drag down, right click and
pick from list to change items in column A and the
formula works

The problem is if you move (left top corner and drag)
an item in column A the formula fails.

Is there a way to disable the move function?
Is there a way to rewrite the formula?

Any help will be greatly appreciated.

TK