G'day,

Off the top of my head I'd say use a Vlookup. Basically just make that table of 16 choices somewhere like you listed above then use a formula similar to:

=VLOOKUP(A1&A2&A3&A4,$Y$1:$Z$16,2,0)

(where Y1:Z16 contains your table out of view).

Hope that helps. -maybe someone has a more interesting.

Adam

Adam

## Like this thread? Share it with others