E 6 Now Clear Content In A12 And B12 What Do You See In C12 D12 And F12 You See N A You Get This Not Availab 1 (37.83 KiB) Viewed 36 times
E 6 Now Clear Content In A12 And B12 What Do You See In C12 D12 And F12 You See N A You Get This Not Availab 2 (40.53 KiB) Viewed 36 times
E 6. Now, clear content in A12 and B12. What do you see in C12, D12, and F12? You see #N/A !!! You get this (Not Available) error because MATCH and VLOOKUP cannot find answers when the lookup value is not given. To avoid #N/A results, we put IF in front of the MATCH and VLOOKUP functions. 7. For all formulas in C12:C20, put IF in front of MATCH and we simply return 0 (zero) if no color (in Column B) is selected. MODE CODERECEDREAS Using C12 as an example: = IF (ISBLANK(B12), 0, otherwise use the same MATCH as you wrote in Step #3)
C12 • fx =MATCH(B12, Color_Choice,0) B c E D Order - Involce Date: 3152 Oreo 333 Road Ewa Beach H 3 Customer Name 4 Address CHY 6 State 7 Zip Code Phone Number . Email Address 10 94010 I 1903 Caicom Color Choice Colum number bosedon calor Product ID Quantity ANT Price for Quantity $11 0 0 wi 11 Product Name 12 am Mesh 14 M 15 10 Or 17 10 w 19 20 21 Uw Price $11 58.00 34 5721 $13. TE 3390 17 555.50 $80. OMES MAW LAD GRATUW GARDIN OR COM COM w 0 a 0 0 Red 311 5130 23 26 Total Order 30th Me State Sales Tax Rate 7:30 State Sales Tax Shipping Chary Woved tordar exceede $95) Invoice To 50.00 5140 SS
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!