Solved

Problem with VLOOKUP

Posted on 2016-11-03
3
53 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
[X]
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
3 Comments
 
LVL 52

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

734 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