Compairing coluumns

Im trying to insert a cost into a coulmn cell based on compairing two columns of part numbers and when a exact match occures take the cost from the corresponding cell and placing it in the orginal cell

example

compair g9:g800 to ao9:ao800 when a match is found take the cost from the corresboding cell ap and insert it into cell s


Thanks for the help

Try

in S9 (?)

=IFERROR(VLOOKUP($G9,$AO$9:$AP$800,2,0),"")

Copy down