| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find two values in worksheet to return one value
I had this posted in another subject, but was getting no response. Thought I
would try it again and hopefully get another answer. Attempting to find identical values in cells B3 & B4 located in another worksheet titled "Density Chart" and to return the value in cell/column D. The Density Chart values are located in column A & B and the value I want returned, depending on the criteria entered would be found on the same row but in column D. Example... Changeable Value in B3 = A123 (can also be completely alpha value and will be different values each time the formula is used. Changeable Value in B4 = 2.00 (always numeric value) Density Chart information ColumnA ColumnB ColumnC ColumnD A123 2.00 55.555 65.555 A123 2.40 55.555 75.555 A123 2.70 55.555 70.555 B123 2.00 45.000 85.000 C123 D123 E123 etc I have tried =if, I have tried =sum product ... at a loss |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find corresponding values on another worksheet | Excel Discussion (Misc queries) | |||
| Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Threaded Mode
