Timeline for Can Someone Please Explain How This VLOOKUP-MATCH-INDEX Formula works
Current License: CC BY-SA 4.0
11 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 27, 2018 at 14:25 | comment | added | PeterH | @ScottCraner Ahh I see, I was thinking along the lines of OFFSET where a 0 would actually mean the first column | |
Jul 27, 2018 at 14:24 | comment | added | Scott Craner |
And no when using 0 in INDEX it returns the whole row or column @PeterH
|
|
Jul 27, 2018 at 14:23 | comment | added | Scott Craner | Yup skipped right over the second criterion. It should just get rid of the INDEX PART but leave the rest of the MATCH replacing the INDEX with either -1,0,1 @PeterH | |
Jul 27, 2018 at 14:21 | comment | added | PeterH | @Scott where it indexes as Row 1 & Column 0, will that not always be the same Cell $A$886 ? | |
Jul 27, 2018 at 14:16 | comment | added | Scott Craner |
@PeterH not and maintain the functionality of the formula. INDEX(Trans_CIQ!$A$886:$AZ$886,1,0) is actually return a 1 dimensional array of 52 values, to the match to search.
|
|
Jul 27, 2018 at 14:15 | vote | accept | Dmitriy | ||
Jul 27, 2018 at 14:08 | comment | added | PeterH |
You could probably use =(VLOOKUP($C10,Trans_CIQ!$A$8:$AZ$95,Trans_CIQ!$A$886,0)*100000)
|
|
Jul 27, 2018 at 14:06 | answer | added | Scott Craner | timeline score: 2 | |
Jul 27, 2018 at 13:57 | history | edited | Scott Craner | CC BY-SA 4.0 |
added 14 characters in body
|
Jul 27, 2018 at 13:55 | review | First posts | |||
Jul 27, 2018 at 15:32 | |||||
Jul 27, 2018 at 13:51 | history | asked | Dmitriy | CC BY-SA 4.0 |