Hi,

I am trying to use LOOKUP, but I have 2 things to lookup within 1 cell and want to concatenate them:

Example:

A
1 U(9)
2 M(8)
3 C(7)

My lookup table:

A B C
1 U All users
2 M Management
3 C Consultants
4 7 Read Only
5 8 Full Access
6 9 Read & Write

I would like to be able to extract the "U(9)" in cell A1 as "All Users - Read & Write"

I would like to know if there is a way to do this without having my U(9) in 2 separate cells.

Thanks,
Stephanie