... =INDEX(A4:K16,MATCH(N3,B4:B16,0),MATCH("List Price",A3:K3,0)),Here is the instruction for this where it asks you to copy after changing it to absolute reference symbols before Pasting it to next cell (N4);(It will not let me copy and paste) a. select N2 and type the number 005. b. Click cell N3 and enter the INDEX function. c. Select A3:K15 for the array argument. d. Use MATCH(N2,B3:B15,0) for the MATCH function row_num argument. e. Use MATCH ("List Price",A3:K3,0)for the MATCH function column_num argument. The result is $1,800,000.00. f. Click N2 and type 007. The result changes to 2,225,000.00. I changed the List price cells by doing this; ($A$3:$K$3,0) did I do this correctly? I am getting an error after pasting into N4.
Then it says: 3. Use typing to create another nested INDEX and MATCH function in cell N4 to determine the square footage based on the MLS number in N2. a. Use the same argument ranges listed in step 2. b. Add absolute reference symbols to the original function as required; thn copy the formula to N4 for easier editing. (THIS IS WHERE I AM DOING SOMETHING WRONG) c. Apply comma formatting to the result in N4. The square footage for MLS number 007 is 3,000. (MY NOTE: (THIS is all based on a house listing with a MLS number, price and etc.) Any one who could help me with this I would appreciate. I am sure this is just me putting my $ in the wrong place, but I get so confused with this. Thank you, K