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.Attachment 23357Attachment 23357
