Nested if and vlookup in Excel 2000

March 18, 2009 at 04:07:06
Specs: Windows XP
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?

See More: Nested if and vlookup in Excel 2000

Report •


#1
March 18, 2009 at 05:33:42
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")


Report •

#2
March 18, 2009 at 09:19:07
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.

Report •

Related Solutions


Ask Question