Hi Robert Thanks once again for your courteous reply to my question posted in the thread Return the value from the adjacent column for the nth occurence.My qestion basically was how would I modify the formulae if the value to be looked up was listed in a column unlike in a row as ithe case stated in the example .Specially if the column to be looked up was in another sheet or anothr workbook.In most of the cases I would use vlookup but doing that would always return the first occurences for values repeating themselves. Please find attached a orkbook which will help you understand my Question better.I am using names of cricketers and cricket teams as I connect less with soccer!!!!Please refer sheet 1 and sheet 2 of the workbookw
Reference to the thread link - Return the value from the adjacent row for the nth occ