Forum Discussion
Same Formula, Same Input, Different Results - VLOOKUP with nested IF referencing two columns
I use excel in conjunction with a barcode scanner to create attendance sheets that have sign in / sign out data for live classes. In my excel file, I work with two sheets: Attendee Information and Si...
Solution found! See my post on the Excel subReddit
https://www.reddit.com/r/excel/comments/b34r2w/same_formula_same_input_different_results_vlookup/
jonesin4adoob suggested:
"The problem is with your if statement that references the entire column C. Unless I’m mistaken, you’re looking to see if that specific name in the names and numbers sheet has a value in column C. If true then return 6 else 3. If that’s the case, change your if statement to something like if( VLookup (B2, names and numbers A:C, 3,0)=“”, rest of formula here...."
So now the full formula is
=IF(B2="","",VLOOKUP(B2,'Names and Numbers'!$A$2:$Z$999,IF(VLOOKUP(B2,'Names and Numbers'!$A:$C,3,0)="",6,3),FALSE))
