Without knowing what your selection criteria is, it is difficult to answer,
but for example if you are looking for a maximum something like
=MAX(Sheet2!A1,Sheet3!A1)
would work

"Gailwdz" wrote:

I'm trying to create a link between worksheets that chooses between two
values in two different cells, and chooses one of them. What function, if
any, could I use?