Look up

[WCE_123]

Hi,

I have attached sheet - I would like

input in Cell D7 this looks at D2:D5 if its equal to then copy A2 & B2 into A7 &B7.

Then repeat for D8

Cheers

WCE

[alvin-chung]

Hi WCE,

Try formula below and copy across A7:B8

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[alvin-chung]

Thanks for the reputation


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin