I have been struggling with the use of the LOOKUP function in that it does not function as expected without a list of ascending values. This seems to be not very useful.
I am trying to construct a small database of raw materials and their prices. This is on sheet 1.
On sheet 2 I am building something like a form where the various raw materials for a certain project can be entered and the cost of each material appears beside it via use of a look up command referring to the master list on sheet 1.
The list of raw materials grows and it doesn't make sense (and won't be useful with multiple users) if we have to keep the list sorted. It seems silly.
I have investigated the use of VLOOKUP but I'm not having success yet.
I have seen other mentions and work arounds for descending data etc, but with my price list sorting it just doesn't make sense and is not convenient.
Could someone get me started in a new direction,
thanks
-David
I am trying to construct a small database of raw materials and their prices. This is on sheet 1.
On sheet 2 I am building something like a form where the various raw materials for a certain project can be entered and the cost of each material appears beside it via use of a look up command referring to the master list on sheet 1.
The list of raw materials grows and it doesn't make sense (and won't be useful with multiple users) if we have to keep the list sorted. It seems silly.
I have investigated the use of VLOOKUP but I'm not having success yet.
I have seen other mentions and work arounds for descending data etc, but with my price list sorting it just doesn't make sense and is not convenient.
Could someone get me started in a new direction,
thanks
-David