Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
have three columns - data changes, need to find matching data if two of the
match the criteria Data and Rows changes Find matching FTE data if no match enter a zero Lab & Dept stay constant Lab Dept FTE Lab Dept FTE Answers 14 10 3.04 16 10 Need 5.45 14 15 5.63 16 15 formula 0 14 40 3.39 16 30 11.3 14 100 0.19 16 40 0 14 260 6.61 16 50 5.61 16 10 5.45 16 30 11.3 16 50 5.61 Is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP FORMULA EVALUATION NEEDED | New Users to Excel | |||
Complicated lookup/match formula help needed! | Excel Worksheet Functions | |||
Formula help needed! lookup/match unsure which | Excel Worksheet Functions | |||
VLOOKUP formula needed | Excel Discussion (Misc queries) | |||
Vlookup formula needed? | Excel Worksheet Functions |