PDA

View Full Version : Lookup formula Corresponding value in anywhere in array



satish gubbi
12-07-2018, 06:18 AM
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.2335723357