If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Edit VLOOKUP Formula to look at an additional column

Thread starter realniceguy5000
Start date Jun 6, 2014

realniceguy5000

Board Regular

Jun 6, 2014

Hello, I currently have the 1st formula below which has been working just fine, however now that we have duplicate lot numbers in a column and it now returns the same value for both item numbers. What I would like is it to look at an additional column to separate these type of problems. Here is the formula I need to edit:

Code:

=IF(ISERROR(VLOOKUP(E2&"",OFFSET('Lot Scans'!$A$1,0,0,COUNTA('Lot Scans'!$A:$A),5),5,FALSE)),0,VLOOKUP(E2&"",OFFSET('Lot Scans'!$A$1,0,0,COUNTA('Lot Scans'!$A:$A),5),5,FALSE))

Basically I need to merge the formula above with this one below

Code:

=IF(ISERROR(VLOOKUP(D2&"",OFFSET('Lot Scans'!$B$2,0,0,COUNTA('Lot Scans'!$B:$B),4),4,FALSE)),0,VLOOKUP(D2&"",OFFSET('Lot Scans'!$B$2,0,0,COUNTA('Lot Scans'!$B:$B),4),4,FALSE))

Could someone help me complete this? Thanks as always for the help. Mike