I need to know as to how to use VLookup and Match function in excel, which can search for the exact match, and replace the cell if False. If True, then leave the data in the cell as it is.

Excel 1 spreadsheet | Excel 2 spreadsheet |

BroadbandContracts.November2011toNovember2012 | Broadband Contracts.November2011 to November 2012 |

Vendor.Contracts | Vendor.Contract |

Time.Overrides.USCurrent(Dates) | Time.Overrides.USCurrent(Dates) |

Time.Schedule. | Time..USJanuary2002toJuly2008 |

Time.Schedule.USNovember2007toCurrent | Time.Schedule.USNovember2007toCurrent |

Time.Schedule.USJanuary2002toJuly2008 | Vendor.PurchaseOrders.Cu |

Time..USNovember2007toCurrent | Time..US November 2007 to Current |

Time..USJanuary2002toJuly2008 | Time.Schedule. |

UnemployeementClaims | UnemployeementClaims |

Vendor.PurchaseOrders.Cu | Time.Schedule.USJanuary2002toJuly2008 |

<colgroup><col><col></colgroup><tbody>

</tbody>

I tried this VLookup function, which leaves the data in the cell if True, and if False, it displays (#N/A).

=VLOOKUP(Sheet4!A1,Sheet5!A1:A117,1,FALSE)

Can anyone guide me as to how to use the VLookup, Match function, and replace the cell data if it does not match.

Appreciate any feedback.

Thanks,