Formula =IF(SERROR)

Hi Guys,

WHAT I NEED TO DO IS AT THE MOMENT THIS FORMUAL CHECKS THE PACK BACK DATA FOR E:E I ALSO NEED THIS FORMUAL TO CHECK COLUMNS F:F & G:G

HOW WOULD I EXTEND THE FORMULA TO CHECK THE OTHER 2 COLUMS

FORMULA BELOW

=IF(ISERROR(VLOOKUP(G2,'Pack Back Data'!E:E,1,FALSE)),"NOT IN","IN")

Originally Posted by 6StringJazzer

Please do not post in all caps.

=IF(ISERROR(MATCH(G2,'Pack Back Data'!E:G,0)),"NOT IN","IN")

Sorry about caps. for some reason that dont seem to work?

Hi Guys,

what i need to is at the moment the formula checks the pack data for E:E and if the data is in columns E:E it will show as in if its not in E:E it will show as not in

what i need is for it to also check all of column F:F and G:G so in this case it will be checking E:E, FF & G:G how would i do that?


Forumla Below

=IF(ISERROR(VLOOKUP(G2,'Pack Back Data'!E:E,1,FALSE)),"NOT IN","IN")

Is there no way of me using the same formula as before
=IF(ISERROR(VLOOKUP(G2,'Pack Back Data'!E:E,1,FALSE)),"NOT IN","IN")

and adding F:F & G:G

that formula seems to slow excel down :S

VLookup by definition checks the first column of the array you select. If you want to check 3 different columns you would need to use 3 different vlookup functions in the formula which would be a lot slower than 6String's suggestion.