#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 77
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable Lookup/Double Lookup Ryan[_2_] Excel Worksheet Functions 8 May 14th 07 09:44 PM
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup JBush Excel Worksheet Functions 3 January 4th 07 12:14 AM
Sumproduct - Condition based on lookup of a Lookup Hari Excel Discussion (Misc queries) 12 May 31st 06 09:28 AM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
How do I lookup and return different values when the lookup value. kg Excel Discussion (Misc queries) 1 January 20th 05 01:53 AM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"