Thanks to all for your quick replies - this way seems to be working the best.
Appreciate the help from all who answered!
Phil

Office Helper wrote:
You can use the Look up function.
Put this formula in the cell where you want the percent to display.

Let's say cell D1 has the value you want to look up. You tell it to look in
columns AA9:AA14 to find a matching value and in AC9:AC14 to find the percent.

=LOOKUP(D1,AA9:AA14,AC9:AC14)

This is much easier than nested if statements.

Hi - hope someone can help with this.

[quoted text clipped - 30 lines]
Any help would be appreciated.
Thx, Phil

--
Message posted via http://www.officekb.com