Excel VBA Vlookup with Ranges
I have vlookup formula that takes the value of A2 and returns the corresponding match found in my Lookup_Table in cell O2, this lookup continues for the rows underneath.
How would I modify this code to lookup a range of values in A:M, with the results placed in O:AA? Or do I have to manually code each column separately?
With Sheets("Example")
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Formula = _
"=IF(ISERROR(VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE)),0,VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE))"
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value = _
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value 'Comment out if you'd like to leave the above formula in place
End With
excel vba excel-vba vlookup
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
add a comment |
I have vlookup formula that takes the value of A2 and returns the corresponding match found in my Lookup_Table in cell O2, this lookup continues for the rows underneath.
How would I modify this code to lookup a range of values in A:M, with the results placed in O:AA? Or do I have to manually code each column separately?
With Sheets("Example")
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Formula = _
"=IF(ISERROR(VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE)),0,VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE))"
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value = _
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value 'Comment out if you'd like to leave the above formula in place
End With
excel vba excel-vba vlookup
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE))is redundant, you should be using something like=IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)
– Michal Rosa
Nov 14 '18 at 2:36
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46
add a comment |
I have vlookup formula that takes the value of A2 and returns the corresponding match found in my Lookup_Table in cell O2, this lookup continues for the rows underneath.
How would I modify this code to lookup a range of values in A:M, with the results placed in O:AA? Or do I have to manually code each column separately?
With Sheets("Example")
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Formula = _
"=IF(ISERROR(VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE)),0,VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE))"
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value = _
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value 'Comment out if you'd like to leave the above formula in place
End With
excel vba excel-vba vlookup
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
I have vlookup formula that takes the value of A2 and returns the corresponding match found in my Lookup_Table in cell O2, this lookup continues for the rows underneath.
How would I modify this code to lookup a range of values in A:M, with the results placed in O:AA? Or do I have to manually code each column separately?
With Sheets("Example")
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Formula = _
"=IF(ISERROR(VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE)),0,VLOOKUP(A2,'Lookup_Table'!A:H,4,FALSE))"
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value = _
.Range("O2:O" & .Range("A" & Rows.Count).End(xlUp).Row).Value 'Comment out if you'd like to leave the above formula in place
End With
excel vba excel-vba vlookup
excel vba excel-vba vlookup
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
edited Nov 14 '18 at 12:44
user3596788
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
asked Nov 14 '18 at 2:10
user3596788user3596788
55111
55111
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE))is redundant, you should be using something like=IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)
– Michal Rosa
Nov 14 '18 at 2:36
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46
add a comment |
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE))is redundant, you should be using something like=IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)
– Michal Rosa
Nov 14 '18 at 2:36
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula
=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)) is redundant, you should be using something like =IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)– Michal Rosa
Nov 14 '18 at 2:36
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula
=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)) is redundant, you should be using something like =IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)– Michal Rosa
Nov 14 '18 at 2:36
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46
add a comment |
1 Answer
1
active
oldest
votes
Assuming Lookup_Table = 'Lookup_Table'!A:H, you could try something like:
With worksheets("Cross_Walk") ' Assumes Activeworkbook
.Range("E2:H" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = _
"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"
End With
We assign the formula to range
E2:H?where?is whatever the last row is determined to be.Excel observes relative and absolute references when assigning the same formula to a range of cells.
So since
A2in the VLOOKUP has a relative row and column reference (no $ signs), it will change toB2when the formula is entered inF2-- and so forth for the remaining columns and rows.Also, if you're going to test whether the result of the VLOOKUP is an error, and then conditionally assign either zero or the matching value, you may as well just use IFERROR in your formula -- rather than performing the VLOOKUP twice.
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columnsA:M(on the sheet in screenshot) to columnsA:Hof the worksheetLookup_Table(a different sheet to the one shown in the screenshot), but the formula itself needs to go in columnsO:AAon the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).
– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to returnblankinstead of0, try changing this line"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"in the code to"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.
– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292204%2fexcel-vba-vlookup-with-ranges%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Assuming Lookup_Table = 'Lookup_Table'!A:H, you could try something like:
With worksheets("Cross_Walk") ' Assumes Activeworkbook
.Range("E2:H" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = _
"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"
End With
We assign the formula to range
E2:H?where?is whatever the last row is determined to be.Excel observes relative and absolute references when assigning the same formula to a range of cells.
So since
A2in the VLOOKUP has a relative row and column reference (no $ signs), it will change toB2when the formula is entered inF2-- and so forth for the remaining columns and rows.Also, if you're going to test whether the result of the VLOOKUP is an error, and then conditionally assign either zero or the matching value, you may as well just use IFERROR in your formula -- rather than performing the VLOOKUP twice.
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columnsA:M(on the sheet in screenshot) to columnsA:Hof the worksheetLookup_Table(a different sheet to the one shown in the screenshot), but the formula itself needs to go in columnsO:AAon the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).
– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to returnblankinstead of0, try changing this line"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"in the code to"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.
– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
add a comment |
Assuming Lookup_Table = 'Lookup_Table'!A:H, you could try something like:
With worksheets("Cross_Walk") ' Assumes Activeworkbook
.Range("E2:H" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = _
"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"
End With
We assign the formula to range
E2:H?where?is whatever the last row is determined to be.Excel observes relative and absolute references when assigning the same formula to a range of cells.
So since
A2in the VLOOKUP has a relative row and column reference (no $ signs), it will change toB2when the formula is entered inF2-- and so forth for the remaining columns and rows.Also, if you're going to test whether the result of the VLOOKUP is an error, and then conditionally assign either zero or the matching value, you may as well just use IFERROR in your formula -- rather than performing the VLOOKUP twice.
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columnsA:M(on the sheet in screenshot) to columnsA:Hof the worksheetLookup_Table(a different sheet to the one shown in the screenshot), but the formula itself needs to go in columnsO:AAon the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).
– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to returnblankinstead of0, try changing this line"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"in the code to"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.
– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
add a comment |
Assuming Lookup_Table = 'Lookup_Table'!A:H, you could try something like:
With worksheets("Cross_Walk") ' Assumes Activeworkbook
.Range("E2:H" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = _
"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"
End With
We assign the formula to range
E2:H?where?is whatever the last row is determined to be.Excel observes relative and absolute references when assigning the same formula to a range of cells.
So since
A2in the VLOOKUP has a relative row and column reference (no $ signs), it will change toB2when the formula is entered inF2-- and so forth for the remaining columns and rows.Also, if you're going to test whether the result of the VLOOKUP is an error, and then conditionally assign either zero or the matching value, you may as well just use IFERROR in your formula -- rather than performing the VLOOKUP twice.
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
Assuming Lookup_Table = 'Lookup_Table'!A:H, you could try something like:
With worksheets("Cross_Walk") ' Assumes Activeworkbook
.Range("E2:H" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = _
"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"
End With
We assign the formula to range
E2:H?where?is whatever the last row is determined to be.Excel observes relative and absolute references when assigning the same formula to a range of cells.
So since
A2in the VLOOKUP has a relative row and column reference (no $ signs), it will change toB2when the formula is entered inF2-- and so forth for the remaining columns and rows.Also, if you're going to test whether the result of the VLOOKUP is an error, and then conditionally assign either zero or the matching value, you may as well just use IFERROR in your formula -- rather than performing the VLOOKUP twice.
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
edited Nov 14 '18 at 3:42
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
answered Nov 14 '18 at 3:27
chillinchillin
1,459134
1,459134
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columnsA:M(on the sheet in screenshot) to columnsA:Hof the worksheetLookup_Table(a different sheet to the one shown in the screenshot), but the formula itself needs to go in columnsO:AAon the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).
– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to returnblankinstead of0, try changing this line"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"in the code to"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.
– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
add a comment |
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columnsA:M(on the sheet in screenshot) to columnsA:Hof the worksheetLookup_Table(a different sheet to the one shown in the screenshot), but the formula itself needs to go in columnsO:AAon the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).
– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to returnblankinstead of0, try changing this line"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)"in the code to"=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.
– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
Sorry I was unable to get your example working. I modified my question and included a screen shot to simplify the question, does this make more sense now?
– user3596788
Nov 14 '18 at 18:40
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columns
A:M (on the sheet in screenshot) to columns A:H of the worksheet Lookup_Table (a different sheet to the one shown in the screenshot), but the formula itself needs to go in columns O:AA on the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).– chillin
Nov 14 '18 at 20:03
@user3596788 Okay, did it give you an error message? Did the code run okay but the formula/results were wrong? Based on the screenshot, the formula needs to match values in columns
A:M (on the sheet in screenshot) to columns A:H of the worksheet Lookup_Table (a different sheet to the one shown in the screenshot), but the formula itself needs to go in columns O:AA on the worksheet shown -- is that correct? Also, do you really want to fill every row in the columns with the formula (it will likely make the spreadsheet quite slow, if there are 1 million rows to update/recalculate).– chillin
Nov 14 '18 at 20:03
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
It works I put the wrong column range in initially. Regarding the performance I would expect 2-3k rows at most is there a better approach? Also, how do I return blank instead of 0 when no match is found?
– user3596788
Nov 15 '18 at 12:34
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to return
blank instead of 0, try changing this line "=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)" in the code to "=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.– chillin
Nov 15 '18 at 12:53
In my opinion, if the code works fine for you, then there's no need to optimise it further. Also, if you want to return
blank instead of 0, try changing this line "=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),0)" in the code to "=Iferror(VLOOKUP(A2,'Lookup_Table'!$A:$H,4,FALSE),"""")". Technically, this doesn't make the cell blank, it puts a zero-length string into it -- but try it and see if it's okay for you.– chillin
Nov 15 '18 at 12:53
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
It works! I appreciate the help thanks again.
– user3596788
Nov 15 '18 at 13:08
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53292204%2fexcel-vba-vlookup-with-ranges%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Can you explain it a little bit better please - perhaps with screenshots? I find it rather confusing. You are populating range E2:AX and taking value from A2? Also, your formula
=IF(ISERROR(VLOOKUP(B2,Lookup_Table!B:I,4,FALSE)),0,VLOOKUP(B2,Lookup_Table!B:I,4,FALSE))is redundant, you should be using something like=IFERROR(VLOOKUP(A2,Lookup_Table!A:H,4,FALSE),0)– Michal Rosa
Nov 14 '18 at 2:36
I appreciate your response I added a screenshot, hopefully it's less confusing
– user3596788
Nov 14 '18 at 12:46