Look up values

[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.

 

[Frank Kabel]

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

 

[Bill in ABQ]

Try this:

=IF(A1<B2,"BUY",IF(AND(A1>B2,A1<C3),"HOLD",IF
(A1>C3,"SELL",0)))

 

[A]

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.