Merge Data

[sagarsoni7]

excel.PNG

Please see this image. I want to merge this data. Please help me to do so. Any help will be appreciated.

[mohamedJamsheer]

is this what you are looking

CODE]=iferror(vlookup(A1,$F$1:$G$5,2,false),"")[[/CODE]

[mohamedJamsheer]

Please Login or Register  to view this content.

[sagarsoni7]

Please Login or Register  to view this content.

I worked. But through some extent.

Please see here: http://s29.postimg.org/xex2uc713/excel2.png

[mohamedJamsheer]

Please Login or Register  to view this content.

[sagarsoni7]

Please Login or Register  to view this content.

Thanks Dude. It worked! You are awesome