LOOKUP

B

BAKERSMAN

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?
 
T

Toppers

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
 
B

BigPig

BAKERSMAN,

What kind of "CERTAIN DATA"? Can it be anything other than ""?

If you type in this "CERTAIN DATA" what's in cell A1 sheet2? Is there more
or is the only data in just cell A1 in sheet2?

If you want to do a lookup, then you can start by assigning a named range
for your lookup data. Then use data validation in the appropriate cell (ie
a4). In cell a3 you would have to write a vlookup or index match or whatever
based on the value in cell A4.

=vlookup(a4,yournamedrange,number of columns to the right that you want a
new value to appear, # of rows if applicable)

hth

BigPig
 
Top