lookup problem.
I am trying to lookup a column from one worksheet and match it with anohter
column in another worksheet, then I want it to give me the value in the
adjacent cell.
Here is my example:
worksheet A: cell A1: Bstudio2
worksheet B:
A B C D E F
Astudio1 3 Bstudio1 9 Cstudio1 10
Astudio2 4 Bstudio2 0 Cstudio2 5
Astudio3 8 Bstudio3 2 Cstudio3 6
So if worksheet one (A1) matches either column A,C or E in other worksheet
then return B,D or E. Cannot figure out what combination of VlLOOKUP, MATCH
and/or INDEX to use to get answer.
|