VLookup without an exact match

Question

Consider I have following values in Workbook1 (disregard the quotes):

Cell A1 - "C123 - Description"
Cell B1 - "Input"
Cell C1 - "Output"
Cell D1 - "Change"

Now, Workbook2 has

Cell A1 - "C123"

Question:

How do I do a vlookup in Workbook2 for "C123" from Workbook1 since "C123" is not "C123 - Description" i.e. both the A1 values are not exact?

Please let me know if I need to be more clear with my question

Answer 1

Use wild cards:

=VLOOKUP(A1 & " *",Sheet2!A:D,4,FALSE)