Managed to solve it myself
=VLOOKUP(A24, $A$1:$G$206, 2)
=VLOOKUP(cell ref, range to check, 2nd col to take the value from)
Hope this helps someone else.
Rgs
Greg
"GregAVANTIQ" wrote:
I want to be able to automatically generate price confirmations / quotes by
entering the
MAIN TABLE
Product Price1 Price2 Delivery
P1 ぎ183 ぎ172 8-12
P2 ぎ195 ぎ195 30
P3 ぎ412 ぎ70 30
P4 ぎ293 ぎ183 30+
Calculation Table
P2
P4
Here I would type in or select from a dropdown the product P2 & P4 and the
other cells would be automatically completed (lookedup?) using the adjacent
cell reference.
Sure this isn't too complex just need some help from someone with a bit more
knowledge on such items. Thank you in anticipatio of your assistance.
|