Look up values

  • Thread starter Thread starter A
  • Start date Start date
A

A

I am trying to write a formula to look up values in column
B depending on two values in column A.
E.g.

Col A
MyData
First
Second

YourData
First
Second

On a seperate sheet i want to find the value in column B
if it matches MYDATA and FIRST in Column A.

Is there a way i can do that. Thank you for your help.
 
Hi

hope I uderstood you correctly. Assuming your data looks like the
following
A B
mydata 1
first 2
yourdata 3
first 4

and you're searching for "mydata" and "first" the result would be '1'
(adjacent cell to 'mydata')
Then you can use the following formula
=INDEX(B1:B99,MATCH(1,(A1:A99="mydata")*(A2:A100="first"),0))
you have to enter this as array formula (CTRL+SHIFT+ENTER)

One comment: I would suggest that you order your data differently as
this kind of formulas could become complicated

HTH
Frank


lets
 
Frank,

This works. Thank you for your help. This is great help. I
can not rearrange the data as this is one part of a bigger
layout and the other parts do not require the same
formulas. Thanks again.
 
Back
Top