| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formulas to match row in a table from given values
I have a table where column A is the size of the material, e.g.
0.5",1",1.5"..., columb B is the thickness, e.g. 11,14,16, of the material, column C is the weight of the material per size and thickness. Each size (column A) has 3 or more thicknesses (column B). So I'm trying to write a formula that will find the given (size and thickness) values on the same row and return the weight from column C. I've tried L-UP,VL-UP,HL-UP,MATCH,INDEX. MY HEAD IS SWIMMING. Might anyone have a suggestion. advil aint workin no more. hope this isn't TMI Thanks for any response. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Match Values in Rows with Partial Values in Columns | Excel Worksheet Functions | |||
| duplicate table just values not formulas in the table | Charts and Charting in Excel | |||
Threaded Mode
