I've done this by concatenating the two values that you want to compare.

"Ed Milford" wrote:

I am trying to compare two cells in a sheet to a table in another sheet in
order to obtain a value. Is this possible?
In particular I am trying to lookup a works order no. and a stage no. in
order to obtain a dept name. A works order can have more than one stage no.