I have comparable data that I need to assign a numerical value to. For
example: If value #1 (cell b1) is an N - value #2 is "cpa" (cell c1) then the
value I want to assign in cell f1 is 15. How can I get an excel spreadsheet
to read and compare multiple values like this?