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?

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?

Sounds like IF

=IF(Sheet1!A1="A", A1,B1)

--
HTH

Bob Phillips

"Gailwdz" wrote in message
...
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?

Thank you. It did help, but I think I need a nested formula. My data looks a
little like this:

US Received Competent Moderated Verified
114943 R C M V
R C M

What I'm trying to do is determine at which stage the US is at. Example -
the unit standard has been received and marked competent, but has not been
verified yet - then the formula must determine that the cell marked V is
empty, and then determine whether the cell marked M is empty or not, and so
on.

The formula should also check the columns from right to left, to see at what
stage the unit standard is at, at present.

I hope that's not as confusing to you as it sounds to me!


"Bob Phillips" wrote:

Sounds like IF

=IF(Sheet1!A1="A", A1,B1)

--
HTH

Bob Phillips

"Gailwdz" wrote in message
...
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?

try
=if(verified="V","V",if(moderated="M","M",if(compe tent="C","C",if(received="R","R",""))))
where verified is the appropriate cell in the "Verified"column, etc.

"Gailwdz" wrote:

Thank you. It did help, but I think I need a nested formula. My data looks a
little like this:

US Received Competent Moderated Verified
114943 R C M V
R C M

What I'm trying to do is determine at which stage the US is at. Example -
the unit standard has been received and marked competent, but has not been
verified yet - then the formula must determine that the cell marked V is
empty, and then determine whether the cell marked M is empty or not, and so
on.

The formula should also check the columns from right to left, to see at what
stage the unit standard is at, at present.

I hope that's not as confusing to you as it sounds to me!


"Bob Phillips" wrote:

Sounds like IF

=IF(Sheet1!A1="A", A1,B1)

--
HTH

Bob Phillips

"Gailwdz" wrote in message
...
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?

Thanks very much.

"bj" wrote:

try
=if(verified="V","V",if(moderated="M","M",if(compe tent="C","C",if(received="R","R",""))))
where verified is the appropriate cell in the "Verified"column, etc.

"Gailwdz" wrote:

Thank you. It did help, but I think I need a nested formula. My data looks a
little like this:

US Received Competent Moderated Verified
114943 R C M V
R C M

What I'm trying to do is determine at which stage the US is at. Example -
the unit standard has been received and marked competent, but has not been
verified yet - then the formula must determine that the cell marked V is
empty, and then determine whether the cell marked M is empty or not, and so
on.

The formula should also check the columns from right to left, to see at what
stage the unit standard is at, at present.

I hope that's not as confusing to you as it sounds to me!


"Bob Phillips" wrote:

Sounds like IF

=IF(Sheet1!A1="A", A1,B1)

--
HTH

Bob Phillips

"Gailwdz" wrote in message
...
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?