View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
claudard64 claudard64 is offline
external usenet poster
 
Posts: 2
Default select value in table based on values entered in multiple cells

I'm trying to find a formula that will verify the value in many cells within
a row and select a value in a table based on the values entered for those
cells within the row.

in one column, I indicate if the piece of wood in 4/4 or 5/4 in another
column, I indicate the type of wood and finally in another column, I indicate
the quality of wood.

Based on these 3 criterias, I would like to find the appropriate price
(within a table created on a separate tab) based on these criterias.

I'm a bit new to the usage of formulas and can't find the appropriate
formula to use