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

x
Solved

# Problem with VLOOKUP

Posted on 2016-11-03
Medium Priority
74 Views
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.
0
Question by:Bright01

LVL 54

Accepted Solution

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)
``````
and drag it for the similar cells.
0

LVL 27

Assisted Solution

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

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

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.
###### Suggested Courses
Course of the Month7 days, 9 hours left to enroll