Hi,

I have a sheet where there are repeated name and somewhere in repeated name there are corresponding value, I would lookup for corresponding value, irrespective whether it is in first row or 4th row.

I have attached my working here.

Request you get me a vlookup / Lookup formula to pick the corresponding value.Lookup for corresponding value.xlsxLookup for corresponding value.xlsx