LOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 
Back
Top