I'm trying to compare some parts using vlookup. If the part numbers are the same I need to pull in column 5, however if column 5 is blank I need to pull in column 10.

I'm assuming I need an IF statement in the col_index argument, but can't seem to construct it successfully.

=VLOOKUP(A2, G2:R1500,???,FALSE)

Thanks for any input.