Macro to loop between multiple columns and copy the text in one column

[Manish_Gupta]

Hello Guys,

I need a help in creating a one macro which can resolve my below requirements:

1. There are 1000 of rows in sheet and we are using a V-lookup in columns no. – G, H, I and J for fetching the status from multiple sheets for unique app id present in Column B.
2. Generally, between columns no. G, H, I and J; only one column will have the status (could be any text, for ex: approved or conditioned etc.) and other columns will have the “#N/A” (value not available) error.
3. My requirement is, macro has to look for the status in the columns no. G, H, I and J (ignore if column is containing “#NA”) and if found then copy it and do paste special in Column E (in same row).

Any help would be appreciated a lot. Please refer the attached sample sheet.

Thanks