Timeline for Can Someone Please Explain How This VLOOKUP-MATCH-INDEX Formula works
Current License: CC BY-SA 4.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 27, 2018 at 14:27 | history | edited | Scott Craner | CC BY-SA 4.0 |
added 98 characters in body
|
Jul 27, 2018 at 14:25 | comment | added | Dmitriy | actually I think this code is pretty redundant, I just double checked and it actually gives a 0, I'm not sure why someone would write that instead of just put 0 | |
Jul 27, 2018 at 14:24 | comment | added | Scott Craner | Is your data sorted and you want a relative match or an exact match, just replace the whole INDEX with -1,0,1. I will update | |
Jul 27, 2018 at 14:21 | comment | added | Scott Craner | Yup missed that, not sure why it is in there. | |
Jul 27, 2018 at 14:19 | comment | added | Dmitriy | MATCH(lookup_value,lookup_array,match_type) so for the lookup value it is D$9, for the lookup_array it is Trans_CIQ!$A$8:$AZ$8, and for the match_type it is Trans_CIQ!$A$886:$AZ$886 from my understanding, or is this incorrect? | |
Jul 27, 2018 at 14:16 | comment | added | Scott Craner | It is not, it is in the second spot which is where the range to be searched goes. The third criterion is being left blank, which is fine as it is optional. | |
Jul 27, 2018 at 14:15 | vote | accept | Dmitriy | ||
Jul 27, 2018 at 14:15 | comment | added | Dmitriy | Thank you Scott! One more follow up question, why is the INDEX/Array in in the match_type spot, I thought that was only supposed to be a -1,0, or 1? | |
Jul 27, 2018 at 14:13 | history | edited | Scott Craner | CC BY-SA 4.0 |
deleted 3 characters in body
|
Jul 27, 2018 at 14:06 | history | answered | Scott Craner | CC BY-SA 4.0 |