Look up a value based on three different criteria

[LLL0422]

I have two workbooks. I'll call them wkbk1 and wkbk2.


I am looking at three cells in the same row in wkbk1.

I need to identify which row in wkbk2 contains those values and then return a value from a cell in the same row in wkbk2.

How do I structure this look up?

Thank you!

[Kaper]

standard way to do this would be not lookup, but array formula similar to:

Please Login or Register  to view this content.

[LLL0422]

what if for value 1, it depends on the value contained in the cell in the row that I'm looking at?

Is it able to reference the two different workbooks?

Thanks!

[Kaper]

Yes it is. (As far as I remember both workbooks have to be open).

If it is not enough (By the way - have you tried to implement above formula?), my suggestion is: have a closer look at fifth bulletpoint down under rule 13 in http://www.excelforum.com/forum-rule...rum-rules.html

[LLL0422]

Hm, what do you mean by ROW(anycolumn)?

[Kaper]

Exactly wahat I wrote.

Please Login or Register  to view this content.