Reputation: 1618
Please let me know how do I achieve below output state in googlespreadsheet, for given key(Column3) and value(Column4) in below table. This is just a example I've file with huge records.
Input State :
Column1 Column2 Column3 Column4
123 123 ABC
123 456 DEF
123 789 GHI
456
456
456
789
789
Output State :
Column1 Column2 Column3 Column4
123 ABC 123 ABC
123 ABC 456 DEF
123 ABC 789 GHI
456 DEF
456 DEF
456 DEF
789 GHI
789 GHI
I've tried few hacks but didn't work. Dear excel experts please help here.
TIA
Upvotes: 0
Views: 379
Reputation: 84475
In B2 put the following and fill down
=iferror(vlookup(A1,$C$1:$D$3,2,false),"")
Upvotes: 2