| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
table
In Excel 2002 I have the following table;
Column G Column H Row 33 30 $1.05 Row 34 45 $1.00 Row 35 60 $0.95 Row 36 90 $0.85 Row 37 120 $0.79 What I want to do with this is if the value in I5 is 1-30 I want the value from H33 put in J5, if the value in I5 is 31-45 I want the value in J5 to be H34, if the value in I5 is 45-60 I want the value in J5 to be H35, if the value in I5 is 61-90 I want the value in J5 to be H36, and if the value in I5 is 91 or greater I want the value in J5 to be H37. Can you please help me with this? Thanks, Keith |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| table | Excel Discussion (Misc queries) | |||
| table | Excel Worksheet Functions | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
