Excel Formula Challenge #4

This one is quite easy in comparison to the other formula challenges here. By using excel native function you need to get the price of any selected brand. Be the part of my Excel VBA WhatsApp group to see the solution and challenges like this

Excel Formula Challenge

What is your formula solution? share it with people in the commentbox. You can download the test file from here

FormulaChallenge4-1.xlsx (88 downloads)

Join my VBA whatsApp group to know more

Join Our Premium Group

Because learning right is important 

13 replies
  1. Robert H. Gascon
    Robert H. Gascon says:

    The array formula can be avoided by wrapping the lookup array argument of the second MATCH function with the INDEX function, as follows:
    =INDEX($B$5:$Q$12,
    MATCH(E14,$B$5:$B$12,0),
    MATCH(E15,
    INDEX(VLOOKUP(E14,$B$5:$Q$12, {2,5,8,11,14},0),1,0),
    1)*3+1)
    Row 4 was excluded from the range.

    Reply
  2. priti
    priti says:

    =INDEX(rngData,MATCH($E$14,rngCol,0),MATCH($E$15,OFFSET(INDEX(rngData,MATCH($E$14,rngCol,0),1),,,,COUNTA(rngRow)),1)+MATCH($C$16,OFFSET(INDIRECT(ADDRESS(ROW($B$4),MATCH($E$15,OFFSET(INDEX(rngData,MATCH($E$14,rngCol,0),1),,,,COUNTA(rngRow)),0)+COLUMN(B4))),,,,COUNTA(rngRow)),0))

    With CSE

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *