vlookup / match / index solution?

[ollyhughes1982]

[FONT=&quot]Hi,[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Please can someone help - I think I need some sort of vlookup / match / index solution?[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Basically what I need to do is fill the yellow column with the relevant data from the orange column.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]For example: Where it has Sarah Lauder in cell A43, I want to populate cell C43 with the value from cell J255 (i.e. the ‘Age Category’ cell 2 columns adjacent to where Sarah Lauder appears in column G). If the value from column A isn’t in the lookup list (column G) then leave the cell in column C blank.[/FONT]
[FONT=&quot]
File is at below link:

https://1drv.ms/x/s!AtIvkRgReIvwgRXOFewzoaPlI4HK

[/FONT]
[FONT=&quot]Thanks![/FONT]

 

[kweaver]

=iferror(VLOOKUP(A2,$G$2:$J$298,4,FALSE),"")

In C2 and fill down.

If the name in A column isn't found in G, what then? This formula will give you #N/A...oops, yes you did.

 

[ollyhughes1982]

Thanks, that's great!