Hi All,
I Need your Help on lookin up a specific set of alpha numeric unique ID from a cell which will have this Unique ID along with other words.
Corrected Example File attached.
Am sorry i put my query incorrectly previously
Below is what am looking for
Brief description of the Report:
Column A2 to Column C4 is system generated report and Column G2 to G4 is manually captured by user which may or may not have a space or alphanumeric before and after the Unique ID that they capture. This is were am facing issue to look up on user captured data against system generated report to get costing and volume accordingly.
Help needed:
What am lookin at is in Cell H2 we need to look up or search or match the Unique ID that's available in A2 to A4 to G2 once we are able to match this then need to look up for corresponding costing and Volume.
Thank You
Sudhir
Bookmarks