I provided this formula in a Numbers files that has two sheets, Sheet1 and Sheet2, and it works as I need:
INDIRECT( ADDRESS( MATCH($I;Sheet2::Table 1::B) ;3;4;TRUE;"Sheet2::Table 1") )
I explain what it does:
- MATCH - in a cell of Sheet1, it compares the content of the column I (same row as it runs) with the column B of Table 1 of Sheet2;
- ADDRESS - when matched, it takes the position of cell (same row matched) but in column C from the Table 1 of Sheet2;
- INDIRECT - it takes the content of the cell addressed before.
Now, I need to use it in the original Excel file and I think I'm missing something...(and I can't save the Numbers file in to Excel).
how can I convert it?