How can I get excel to look up prices in a table

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i get excel to use data in a table based on the result of a 2
How do I perform extended calculations in a Pivot Table in Excel 2 4
how can i get an table to look like a formatted table 9
How can I get a table caption to show up in the 'List of Tables' 5
How can I get text to equal a numerical value in Excel? 2

Top