How can I change like this?
Hello:
I am sorry to say that I have try but I didn't understand how to
make it successful. I have attached the sample sheet. The original data
was in Sheet-A and already define the name as "Master". May I know how
can I make it work on Sheet-B?
Thanks!
Spiky wrote:
Try this. If the first database is in A:D, and the 2nd is in F:I....
{=INDEX($A$2:$D$6,MATCH(1,($A$2:$A$6=$F2)*($C$2:$C $6=G$1),0),4)}
This can be copied to G2:I100 or however far you need. I assumed you
would enter the Host yourself in Column F.
It is an array, so must be entered with CTRL-SHIFT-ENTER.
|