#### venkyzrocks

##### New Member

- Joined
- Oct 4, 2009

- Messages
- 36

Please refer to the the sheet below. I have used =VLOOKUP("*"&$C$2&"*",$A$1:$B$4,2,FALSE) to get the value in the Final Value column based on Partial Match. But the expected value that I need is R1, R3 , R3 . This is just an eg need to to work for a column which has more than 10000 rows.

So how would I do a partial match vlookup or using the index and match function and retrieve multiple values in a single cell

<colgroup><col width="707"></colgroup><tbody> </tbody> | Value | Values To Be Looked Up Using Partial Match | Final Value Got | |

Thanks! | R1 | Thank | R1 | |

Thank | R2 | |||

Thank You | R3 |

<tbody>

</tbody>

Thanks ,

Venkatesh