Question: 9 10 Adam gets the #N/A! error from the MATCH formula described below. What could be the reason for the error? B12 fx =MATCH(A12, A2:09,0)

 9 10 Adam gets the #N/A! error from the MATCH formula

9 10 Adam gets the #N/A! error from the MATCH formula described below. What could be the reason for the error? B12 fx =MATCH(A12, A2:09,0) D B Diameter (km) 5 Satelies 0 12 0 13 1 1 Planet 2 Mercury 3 Venus 4 Earth 5 Mars 6 Jupiter 7 Saturn 8 Uranus 9 Neptune 10 11 Planet 12 Earth 7 143 121 51 2 67 200 27 13 50 Position #N/A O the referenced range needs to be sorted (ordered alphabetically) The match_type is incorrect O not enough arguments passed to the match function The lookup_array reference is not a column or a row O The lookup_array reference should be anchored O The IFerror function should be used

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!