I would like to ask for vba code to search the given value in another workbook and return the corresponding cell back to the original workbook. Can anyone help please?

Workbook1

A | B | C | |

1 | AB6675-30 | Confirm |

<TBODY>

</TBODY>

Workbook2

A | B | C | |

1 | AB6675-30.3 | 00001 | |

2 | AC53555-25.1 | 00002 |

<TBODY>

</TBODY>

I would like to have cell A1 in workbook1 to be searched in column A workbook2 and return value in column B to workbook 1 column C.

Thank you very much.