AboutTom Ogilvy Expertise Worked with the program for many years - provided assistance on MS Excel Newsgroups since 1997. Have received the Microsoft MVP award annually since 1999.
I don't answer questions on using Excel in a browser
Since I have no way to test this. Prefer not to answer charting questions. I consider myself to be particularly knowledgeable about using VBA internal to Excel but have no problems with formulas and pivot tables either.
Experience Have Used Excel for 15 - 20 years. Answered in excess of 70,000 Excel related questions in MS Excel newsgroups. Unless obvious, please specify whether you want a worksheet function or macro/VBA solution.
Education/Credentials BS General Engineering (concentration in Industrial Engineering)
MS Operations Research Systems Analysis
Question In B5, I have a drop down for the user to pick either VA3, VA4, or VA7.
In another part of the same sheet(K19), I want to fill in a certain value based on what operator chose in B5. The values to use are listed elsewhere (VA3 value is in O6, VA4 value is in O10, and VA7 value is in O14).
Any ideas on how to do this? For example, if operator chose VA3, how do I fill in K19 to use the O6 value?
thanks,
kth
Answer Keith,
Assume your table of "VA" values and corresponding "O" values are in the range of cells M1:N3 as shown:
M1: VA3
N1: O6
M2: VA4
N2: 010
M3: VA7
N3: O14
in K19 put in
=if(B5="","",Vlookup(B5,M1:N3,2,False))
If these values of equivalencies were in another sheet, example Sheet3, located in the same cells (M1:N3) then it would be
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
