How to Check if Cell value exists in Column, and then get the value of the NEXT Cell

Hello Friends, I am back with new trick with excel ..
This week I am  playing with excel and in today's task , I need to check

Check if Cell value exists in Column, and then get the value of the NEXT Cell.

I search pretty much, and finally got this solution which is exactly as per my requirement.

The link is http://stackoverflow.com/questions/12915215/excel-check-if-cell-value-exists-in-column-and-then-get-the-value-of-the-next

Question :  

After checking if a cell value exists in a column, I need to get the value of the cell next to the matching cell. For instance, I check if the value in cell A1 exists in column B, and assuming it matches B5, then I want the value in cell C5.

Answer : 

=IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", INDIRECT(ADDRESS(MATCH(A1,B:B, 0), 3)))

The "3" at the end means for column C.

Hope this help you people and save your time to search things 

Enjoy the day with lots of smile and happiness.....