How to print the 2nd column of a searched string in a csv

[ptey07]

Thanks i will have a play, not sure tho
i have of pictures and a csv the picture file name in column A and location it was taken in Column B
i can get the code to look at the file name then go to the csv and search for the file name and then return the row of data, but i want it to just return the location column of that row. if u get what i mean