Thread: match values

Hi,

Please view the attached picture. I think this is really simple.

Sheet 2 contains the given values

In Sheet 1, Column B (returned age) should return the corresponding value in Sheet 2. I am unable to use vlookup since Column A in Sheet 1 doesn't exactly match what's already given in Sheet 2.

For example, eddie smith is 28 years old (in sheet 2). If I type "eddie" in Sheet1, Column A, Column B should automatically come up with "28"

Please help.

Thanks!!!

You could use VLOOKUP with a wildcard, i.e.

=VLOOKUP(A2&"*",sheet2!A$2:B$5,2,0)

It's exactly what I needed.

Thanks!