Can someone write a macro for me that would have cell A1 lookup the value in cell B1 in a table (C1 to G10) and move the found item into A1 (not coping it)

Thanks