Solved

Formula help

Posted on 2011-03-16
5
237 Views
Last Modified: 2012-05-11
Hello,

Does anyone know of a formula that would be similar to a Vlookup but instead of looking in just one column it would look within a range?
0
Comment
Question by:vegas86
[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
5 Comments
 
LVL 13

Expert Comment

by:hiteshgoldeneye
ID: 35153902
I think you will have to add a new column which will be a concatenation of the values in your range, and use this column for lookup
0
 
LVL 3

Expert Comment

by:ssisworo
ID: 35154083
using INDEX like this :

 INDEX
0
 
LVL 3

Assisted Solution

by:ssisworo
ssisworo earned 25 total points
ID: 35154113
and you can expand like this :

 INDEX manipulation
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 25 total points
ID: 35154676
Hello,

if you want to combine two criteria, you can use something like

=INDEX(C1:C10,MATCH(H2&H3,INDEX(A1:A10&B1:B10,0),0))

see attached. The formula will find the match where column A = green and column B = 3

cheers, teylyn
Book2.xlsx
0
 

Author Closing Comment

by:vegas86
ID: 35160828
Thank you! both work, both are awesome!
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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

691 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