Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |