In the attached lookup table what would be the lookup formula in F22 that would return the appropriate Fabrication Table No. which would be at the intersection of the Item Key (range A3:A15) and the selected column heading (LP, MP, or HP in range I3:K15), which in this example is “MP”
In this example, what is the lookup formula that would return Table No “44”? I have no problem creating the formula if the Item Key Column (A) was instead in Column (H) and adjacent to the three columns in the Fabrication Table. Can you help me with this problem where you deal with two separate isolated ranges within a large table?