Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem with VLOOKUP

Posted on 2016-11-03
3
Medium Priority
?
74 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 54

Accepted Solution

by:
Ryan Chong earned 1200 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 27

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 800 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

824 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