Match, VLookup possible formula needed
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?
|