Hi

Im very new on formulas / V LOOK UP'S and worked out whats below so far and it compares data in column J against data in column B and then put a "0" in to identify missing.

=IF(IFERROR(VLOOKUP(J1,$B$1:$B$9999,1,FALSE),"missing")="missing", 1, 0)

What im trying to do is do the same but also include the following

Column K data to look up against column C of which I believe is =IF(IFERROR(VLOOKUP(K1,$C$1:$C$9999,1,FALSE),"missing")="missing", 1, 0)

Column L data to look up against column D =IF(IFERROR(VLOOKUP(L1,$D$1:$D$9999,1,FALSE),"missing")="missing", 1, 0)

Column M data to look up against column E =IF(IFERROR(VLOOKUP(M1,$E$1:$C$9999,1,FALSE),"missing")="missing", 1, 0)

and if all the data not an exact match across all 4 columns I need the work MISSING inserted and not the number "0"

Also at the moment it looks in rows 1-9999 but is there anyway I can set it up so it looks to last entry will be any numbers before 9999. If you can that dont matter but the matching up of data is important.

Any help greatly appriciated.

Many thanks in advance,

Im very new on formulas / V LOOK UP'S and worked out whats below so far and it compares data in column J against data in column B and then put a "0" in to identify missing.

=IF(IFERROR(VLOOKUP(J1,$B$1:$B$9999,1,FALSE),"missing")="missing", 1, 0)

What im trying to do is do the same but also include the following

Column K data to look up against column C of which I believe is =IF(IFERROR(VLOOKUP(K1,$C$1:$C$9999,1,FALSE),"missing")="missing", 1, 0)

Column L data to look up against column D =IF(IFERROR(VLOOKUP(L1,$D$1:$D$9999,1,FALSE),"missing")="missing", 1, 0)

Column M data to look up against column E =IF(IFERROR(VLOOKUP(M1,$E$1:$C$9999,1,FALSE),"missing")="missing", 1, 0)

and if all the data not an exact match across all 4 columns I need the work MISSING inserted and not the number "0"

Also at the moment it looks in rows 1-9999 but is there anyway I can set it up so it looks to last entry will be any numbers before 9999. If you can that dont matter but the matching up of data is important.

Any help greatly appriciated.

Many thanks in advance,

Last edited: