How can I change like this?
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.
|