Ravi Sir's Cards › Excel
Gift Register in Excel (card 1 of 2)
Revision card 1 for Gift Register in Excel: We gave them earlier: =IFERROR(INDEX($L$5:$L$10,MATCH(A5,$K$5:$K$10,0)),"Not in list") gives ₹1,100; Difference: =IF(ISNUMBER(G7),D7-G7,"") gives ₹599. Includes an example data table.
Read card text
What this card says
1 for Gift Register in Excel: We gave them earlier: =IFERROR(INDEX($L$5:$L$10,MATCH(A5,$K$5:$K$10,0)),"Not in list") gives ₹1,100
Difference: =IF(ISNUMBER(G7),D7-G7,"") gives ₹599. Includes an
Example
data table
Learn this in the lesson: Gift Register for a Function in Excel: Cash Gifts, Items and What We Gave Them Earlier