In this image you can see that I am using MIN formula to get the values from mul

Question

In this image you can see that I am using MIN formula to get the values from multiple table. In this specific cell, the value is 79 which is coming from G18 cell and what I want to do is that I want to show in information that it belongs to table name CPFF which is in cell E21. I don't know how to use VLOOKUP in this situation as the answer coming from multiple tables. Can any one help me how to get the cell reference value? Do I need to create another table to get reference value? Thanx

Home nsert MIN Firm Fixed Price (FFP) Sheet1 Edi Page Layout Formulas Data View Calibri (Body) Number Conditional Delete Merge Cente ormatting as Tab Styles MIN ($C$2,G4,G18,SG$31) 80 10p so 95.25 100 104.75 10 .5 114.25 100 98 target fee tareet pri share ratio 04 0.25 Es 96.25 100 105.75 107.5 11125 115 89 actual cost 04 3s 34 97 100 los 106 112 actual cost 85 94.75 100 105.25 110.s 115.75 121 835 94.5 105.S Plus Fixed Fe 80 100 100 0.05 MIN GA618 SG$31 94,7 MIN (number umber2l, Doumber3l, Inumber4l, Inumber5 100 100 81,25 87,5 93,7 X Auto Sum Share Sort & 00%

Explanation / Answer

create another table.

The general syntax of the function is:

VLOOKUP( lookup_value, table_array, col_index_num, [range_lookup] )  

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.