View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] klehnhardt@carolina.rr.com is offline
external usenet poster
 
Posts: 2
Default 2 columns of data to return an answer (Vlookup???)

On Sep 2, 2:14*pm, wrote:
Here is an example of the spreadsheet I have:

Width * *Thick * *Cost
1 * * * * * 1 * * * * *$20
1 * * * * * 2 * * * * *$25
1 * * * * * 3 * * * * *$30
2 * * * * * 1 * * * * *$25
2 * * * * * 2 * * * * *$30
3 * * * * * 3 * * * * *$35

I want my salespeople to enter in the width in one cell and the
thickness in another cell and have it return the cost. *I imagine I
will have to use the Vlookup function.


I need to add that I am looking for some help on which formula to use
to achieve thisl.