Need help to find value with Partial lookup

[vijavad]

Hi All

I have attached an excel sheet for your reference.

I have names in the sheet1 and what i need is i want to lookup for the value in the other sheet2.

How to write a partial lookup formula to get the value from sheet2 with exact value.

All names has keyword Shaik.

[Pete_UK]

You don't need a partial lookup in your example - put this in cell B2 of Sheet1:

=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"")

then copy down as required.

Hope this helps.

Pete