Use something like this in D50 of Worksheet B
=IF('WorkSheet A'!A2100,'WorkSheet A'!A2,"Not 100")

"Maureen" wrote:

I am trying to create a formula in which I am able to copy data from one
worksheet to a cell of a different worksheet in the SAME workbook based on
specific criteria.

For example, if cell A2 on Worksheet A contains item data, I want to copy
that exact data to Worksheet B cell D50. I need to use a formula as there
will be additional criteria added later on.

How should I proceed?