LOOKUP
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? |
LOOKUP
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? |
LOOKUP
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 "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? |
All times are GMT +1. The time now is 12:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com