Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Problem with VLOOKUP

Posted on 2016-11-03
3
45 Views
Last Modified: 2016-11-03
EE Pros,

I've been through the training; used the model; exercised the help..... and for some reason, cannot get VLOOKUP to work for filling out a table.  SEE F38.

Can you take a look?

B.
RadarChartMultiVariablev5.xlsm
0
Comment
Question by:Bright01
3 Comments
 
LVL 50

Accepted Solution

by:
Ryan Chong earned 300 total points
ID: 41872385
use this formula for cell F38:

=OFFSET($F$29,MATCH(F15,F$30:F$34,0),-1)

Open in new window

and drag it for the similar cells.
RadarChartMultiVariablev5_b.xlsm
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 200 total points
ID: 41872404
use VLOOKUP with choose.

here it is put this in F38 =VLOOKUP(F15,CHOOSE({1,2},$F$30:$F$34,$E$30:$E$34),2,0)
0
 

Author Closing Comment

by:Bright01
ID: 41873054
Great job guys...... I actually tried Ryan's solution out first and since it worked well, used it.  Appreciate the effort and it was a big help.  

I've added another question concerning the model.  Hope you will take a look.

https://www.experts-exchange.com/questions/28980922/Macro-help-for-checking-and-unchecking-cells.html

Thanks again,

B.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question