I have two excel sheets(Let’s say A and B) with approx 1700 rows Data with one common ID with sheet A has some missing data fields which I want to bring from sheet B and I am using lookup function to get missing data against common ID’s. I already have brought missing column data into one sheet for better visualization and using this formula
=LOOKUP(E2,$F$2:$F$1700,$G$2:$G$1700)

but the problem is the results are not consistent(for initial rows they are good but after that its messed up) Initially it found out it is sorting of ID’s that was fixed that by sorting ID’s but not much difference in results and also tried VLOOKUP but having error in it.

=VLOOKUP(E2,$F$2:$F$1700,$G$2:$G$1700,FALSE )

Col E and F has ID’s and Col F data need to be pulled against Column F