I'm just now getting around to trying this again and yes, that's a huge help.

Thanks Pete!
--
Krista


"Pete_UK" wrote:

You can only nest up to 7 IF statements, so beyond that you have to
approach things differently. As you surmise, it would be better to have
a table of 24 entries, where the first column is made up of both your
options from column A and B (concatenated together) and then the second
column of your table would be the associated values. Let's assume the
table occupies L1 to M24. Then in C1 you could enter this formula:

=VLOOKUP(A1&B1,L$1:M$24,2,0)

A1 and B1 are joined together (concatenated) - VLOOKUP tries to find a
match between this first parameter and the first column of the table
defined in the second parameter (in this case L1:M24). If a match is
found, then data is returned from column 2 of the table (the 3rd
parameter). The final parameter indicates what type of match - a zero,
or FALSE, indicates you are looking for an exact match. If there is no
match then the function returns #N/A - if you want to avoid this then
you can change the formula to:

=IF(ISNA(VLOOKUP(A1&B1,L$1:M$24,2,0)),"",VLOOKUP(A 1&B1,L$1:M$24,2,0))

and now you would get a blank returned if there is no match.

Hope this helps.

Pete