0

I am trying to pull a value from a data pile based on text value and quantity range. Using Index I can use Match to find the correct row but i cannot seem to find a way to get the correct column.

=INDEX(A1:D4,MATCH(G2,A:A,0),[match(H2,1:1,1)]) == .7 in Value column below

Table

I am just getting errors for finding anything that belongs in the Value column

BigBen
  • 46,229
  • 7
  • 24
  • 40
user514
  • 1
  • Possible duplicate of [Excel - VLOOKUP vs. INDEX/MATCH - Which is better?](https://stackoverflow.com/questions/48348889/excel-vlookup-vs-index-match-which-is-better) – Samuel Hulla May 15 '19 at 21:26
  • 4
    `1-10`, `11-20` and `21-30` are text. Match based on text will most likely fail or not return what you want. You could return the results you want by changing the headers to 0, 10, and 20. – BigBen May 15 '19 at 21:27
  • @BigBen, I believe your comment is helpful enough to be an answer. – George Menoutis May 16 '19 at 08:42
  • @BigBen Agreed, then you can just use `IFERROR(MATCH(H2,$A$1:$D$1,1),0)+1` as the second argument... – Glitch_Doctor May 16 '19 at 09:02

0 Answers0