LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost ability to select multiple cells w/ values & see sum, why? Marianne New Users to Excel 1 October 19th 07 01:00 AM
Select correct worksheet based on data entered into a cell Harry Stevens Excel Worksheet Functions 2 May 13th 07 07:57 AM
how do I make drop-down list select based on 1st letter entered? Missykender Excel Discussion (Misc queries) 3 October 6th 05 11:55 PM
can excel draw a shape based on values entered in cells Milo Excel Worksheet Functions 1 April 6th 05 01:36 AM
Selecting data from a list based on entered values GrantM Excel Discussion (Misc queries) 1 December 20th 04 10:59 AM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"