in A3:

=IF(A4=123,Sheet2!A1,"????")

If A4=123, then put Sheet2!A1 in A3: if not, put ??? - substitute ??? for
your value

If you want a select of data in A4:


=IF(OR(A4=123,A4=456,A4=.....),Sheet2!A1,"????")

HTH



"BAKERSMAN" wrote:

IF I TYPE IN CERTAIN DATA IN CELL A4, I WANT TO POPULATE CELL A3 WITH DATA
FROM CELL A1 ON SHEET 2. HOW DO I DO THIS?