Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Nested if and vlookup in Excel 2000
Name: caabaat Date: March 18, 2009 at 04:07:06 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
I have 2 charts, and want to say if the answer is 1 in the first chart, use the vlookup function to get the answer out of the second chart. Same with if the answer in the first chart is 2. Can I do this?
Name: DerbyDad03 Date: March 18, 2009 at 05:33:42 Pacific
Reply:
What do you mean you have "charts"?
Excel charts are graphs, etc. You can't answer a chart.
Does this help?
=IF(OR(A1=1,A1=2),VLOOKUP(A1,D1:E5,2,0),"A1 isn't 1 or 2")
0
Response Number 2
Name: caabaat Date: March 18, 2009 at 09:19:07 Pacific
Reply:
Sorry - I have one group of data in which a number is generated based on the selection made in a drop down. The drop downs indicate what kind of product a person is purchasing. The second group of data has 5 columns. The first is the value being purchased; the rest are pricing columns. Each product type selected in the drop-down has different pricing. For example; if you choose Gold Form $3,000 the price might be $500, for Silver Form $3,000 the price might be $350 etc. I am trying to automatically put the price into a separate cell once the user selects the product and the value.
Summary: Hi all - first time poster here - been having at a multiple If AND statement in Excel that I just can't get right. There are four variables and I'm trying to combine them all in one IF statement. Se...
Summary: I have two different date where I want to know the no. of days, weeks, months and year. Is there any formula in Excel 2000 which can help me to solve this problem. Thanks ...
Summary: When entering an AlphaNumeric in COL A, I would like to check contents of all previous cells in COL A for IDENTICAL entry, and warn or prevent continuing. Cannot have DUPLICATES in COL A. Entries will...
0 
