shadedlight
Member
Hello,
In column E3 I have a Indexmatch formula. It's indexing column A to match E1, which is the value of zero.
In column F3 I have an Indexmatch formula. It's indexing column A to match F1, which is the value of zero.
In columnG, H, I, and J I have different ranges that I would l like to create an indexmatch formula.
I want the indexmatch formulas to match all the products in column A with the respective numbers or ranges in E1, F1, G1, H1, I1, J1.
I need help with the formula that adjusts the index matches. For example, In E4 the next match would be Baiwei A4, etc.
I also need help with writing a formula for indexmatch that accounts for ranges. For example, G1 is a range from 2 - 4. The formula needs to account for a match of ranges between 2-4. Thank you
In column E3 I have a Indexmatch formula. It's indexing column A to match E1, which is the value of zero.
In column F3 I have an Indexmatch formula. It's indexing column A to match F1, which is the value of zero.
In columnG, H, I, and J I have different ranges that I would l like to create an indexmatch formula.
I want the indexmatch formulas to match all the products in column A with the respective numbers or ranges in E1, F1, G1, H1, I1, J1.
I need help with the formula that adjusts the index matches. For example, In E4 the next match would be Baiwei A4, etc.
I also need help with writing a formula for indexmatch that accounts for ranges. For example, G1 is a range from 2 - 4. The formula needs to account for a match of ranges between 2-4. Thank you