Mr. Milligan wants a lookup page in which when he selects an item number, a summary description will display. The following is an example for A00930 The annual gross profit for 4' Windmill is $3,081.33. Items stay in inventory about 499.38 days. There are 275 items available. Use the table for reference.

What is the excel formula to display this? Thank you! Will thumbs up asap if correct.

Best way to design this on excel so it can look professional and easy to navigate?

A B D E F G H 1 K L M N 140 1 Item No. 2 A00930 3 A00940 4 A00820 5 A00720 6 A00810 7 A00740 8 A00610 9 A00120 10 A00730 11 A00710 12 A01110 13 A01100 14 A00620 15 A00950 16 A00210 17 A00750 18 A00420 19 A00910 20 A01120 21 A00530 22 A00920 23 A00310 24 A00320 25 A00140 26 A00130 27 A01130 28 A00960 29 A00430 30 A01140 31 A00110 32 A00100 33 A00520 34 A00510 35 A00150 36 A00410 Description 4' Windmill 6' Windmill 8' x 40' Covered Bridge 8' x 10' Cedar Shed 6' x 20' Covered Bridge 8' x 10' Cedar Cabana Shed 10' Octagon Cedar Gazebo 12' x 20' Aluminum Shed 6' x 10' Cedar Garden Hut 4' x 6' Cedar Shed Majesty Copper Trellis Monroe Wooden Trellis 12' Cedar Octagon Gazebo 6' Wishing Well 8' x 10' Aluminum Barn 6' x 6' Cedar Garden Hut 8' x 12' Wood Barn Wagon Planter Boston Folding Trellis 8' Child's Picnic Table Mailbox Planter 12' X 8' Double Door Aluminum Shed 16' x 10' Double Door Aluminum Shed 8' x 4' Aluminum Shed 6' x 4' Aluminum Shed Miniature Folding Trellis 12' Wishing Well 10' x 16' Wood Barn Milligan's Superior Trellis 10' x 8' Aluminum Shed 8' x 6' Aluminum Shed 3' x 7' Picnic Table 8' x 10' Picnic Table 10' x 14' Aluminum Shed 8' x 10' Wood Barn Unit Sales Unit Cost Price $30.66 $45.99 $43.99 $65.99 $2,509.72 $4,700.00 $1,135.32 $1,702.99 $1,250.00 $1,400.99 $1,148.56 $1,607.99 $2,499.99 $2,999.99 $1,393.56 $1,950.99 $1,135.00 $1,350.00 $333.33 $500.00 $379.29 $505.72 $202.30 $252.87 $2,963.99 $3,430.99 $53.32 $79.99 $840.47 $1,050.59 $879.99 $950.78 $751.87 $999.99 $11.42 $15.99 $145.92 $207.56 $210.59 $350.99 $21.02 $27.99 $1,043.57 $1,304.47 $1,141.84 $1,507.24 $424.58 $620.75 $346.36 $519.59 $48.00 $54.87 $130.66 $195.99 $808.26 $1,074.99 $764.81 $899.78 $185.17 $249.99 $148.14 $199.99 $207.42 $299.99 $269.28 $399.99 $650.99 $1,200.00 $541.33 $804.49 Average On Hand Average Unit Sales/Year Cost of Average Inventory 275 201 $8,431.50 300 278 $13,197.00 2 2 $5,019.44 72 75 $81,743.04 42 75 $52,500.00 75 136 $86,142.00 71 144 $177,499.29 32 65 $44,593.92 80 175 $90,800.00 80 200 $26,666.40 14 35 $5,310.06 10 25 $2,023.00 15 39 $44,459.85 300 780 $15,996.00 75 202 $63,035.25 114 325 $100,318.86 48 140 $36,089.76 237 702 $2,706.54 12 42 $1,751.04 44 157 $9,265.96 230 845 $4,834.60 80 302 $83,485.60 12 50 $13,702.08 50 215 $21,229.00 50 241 $17,318.00 20 100 $960.00 25 147 $3,266.50 10 67 $8,082.60 1 7 $764.81 50 400 $9,258.50 48 475 $7,110.72 77 850 $15,971.34 26 299 $7,001.28 20 $13,019.80 50 700 $27,066.50 Annual Sales $9,243.99 $18,345.22 $9,400.00 $127,724.25 $105,074.25 $218,686.64 $431,998.56 $126,814.35 $236,250.00 $100,000.00 $17,700.20 $6,321.75 $133,808.61 $62,392.20 $212,219.18 $309,003.50 $139,998.60 $11,224.98 $8,717.52 $55,105.43 $23,651.55 $393,949.94 $75,362.00 $133,461.25 $125,221.19 $5,487.00 $28,810.53 $72,024.33 $6,298.46 $99,996.00 $94,995.25 $254.991.50 $119,597.01 $300,000.00 $563, 143.00 Cost of Goods Sold Annual Gross Profit $6,162.66 $3,081.33 $12,229.22 $6,116.00 $5,019.44 $4,380.56 $85,149.00 $42,575.25 $93,750.00 $11,324.25 $156,204.16 $62,482.48 $359,998.56 $72,000.00 $90,581.40 $36,232.95 $198,625.00 $37,625.00 $66,666.00 $33,334.00 $13,275.15 $4,425.05 $5,057.50 $1,264.25 $115,595.61 $18,213.00 $41,589.60 $20,802.60 $169,774.94 $42,444.24 $285,996.75 $23,006.75 $105,261.80 $34,736.80 $8,016.84 $3,208.14 $6,128.64 $2,588.88 $33,062.63 $22,042.80 $17,761.90 $5,889.65 $315,158.14 $78,791.80 $57,092.00 $18,270.00 $91,284.70 $42,176.55 $83,472.76 $41,748.43 $4,800.00 $687.00 $19,207.02 $9,603.51 $54,153.42 $17,870.91 $5,353.67 $944.79 $74,068.00 $25,928.00 $70,366.50 $24,628.75 $176,307.00 $78,684.50 $80,514.72 $39,082.29 $162,747.50 $137,252.50 $378,931.00 $184,212.00 Gross Margin Ratio Markup Percentage Inventory turnover Days in Inventory 33.33% 50.00% 1 499 33.34% 50.01% 1 394 46.60% 87.27% 1 365 33.33% 50.00% 1 350 10.78% 12.08% 2 204 28.57% 40.00% 2 201 16.67% 20.00% 2 180 28.57% 40.00% 2 180 15.93% 18.94% 2 167 33.33% 50.00% 3 146 25.00% 33.33% 3 146 20.00% 25.00% 3 146 13.61% 15.76% 3 33.34% 50.02% 3 140 20.00% 25.00% 3 136 7.45% 8.04% 3 128 24.81% 33.00% 3 125 28.58% 40.02% 3 123 29.70% 42.24% 4 104 40.00% 66.67% 4 102 24.90% 33.16% 4 99 20.00% 25.00% 4 97 24.24% 32.00% 4 88 31.60% 46.20% 4 85 33.34% 50.01% 5 76 12.52% 14.31% 5 73 33.33% 50.00% 6 62 24.81% 33.00% 7 54 15.00% 17.65% 7 52 25.93% 35.01% 8 46 25.93% 35.00% 10 37 30.86% 44.63% 11 33 32.68% 48.54% 12 32 45.75% 84.33% 13 29 32.71% 48.61% 14 26 250 37 38 39 40 41 42 43 44 Total 45 Average 46 Min 47 Max 48 $1,100,620.24 $31,446.29 $764.81 $177,499.29 $4,637,018.24 $132,486.24 $5,487.00 $563,143.00 $3,449,363.23 $98,553.24 $4,800.00 $378,931.00 $1,187,655.01 $33,933.00 $687.00 $184,212.00 $11.42 $2,963.99 $15.99 $4,700.00 26.76% 7.45% 46.60% 38.71% 8.04% 87.27% A B D E F G H 1 K L M N 140 1 Item No. 2 A00930 3 A00940 4 A00820 5 A00720 6 A00810 7 A00740 8 A00610 9 A00120 10 A00730 11 A00710 12 A01110 13 A01100 14 A00620 15 A00950 16 A00210 17 A00750 18 A00420 19 A00910 20 A01120 21 A00530 22 A00920 23 A00310 24 A00320 25 A00140 26 A00130 27 A01130 28 A00960 29 A00430 30 A01140 31 A00110 32 A00100 33 A00520 34 A00510 35 A00150 36 A00410 Description 4' Windmill 6' Windmill 8' x 40' Covered Bridge 8' x 10' Cedar Shed 6' x 20' Covered Bridge 8' x 10' Cedar Cabana Shed 10' Octagon Cedar Gazebo 12' x 20' Aluminum Shed 6' x 10' Cedar Garden Hut 4' x 6' Cedar Shed Majesty Copper Trellis Monroe Wooden Trellis 12' Cedar Octagon Gazebo 6' Wishing Well 8' x 10' Aluminum Barn 6' x 6' Cedar Garden Hut 8' x 12' Wood Barn Wagon Planter Boston Folding Trellis 8' Child's Picnic Table Mailbox Planter 12' X 8' Double Door Aluminum Shed 16' x 10' Double Door Aluminum Shed 8' x 4' Aluminum Shed 6' x 4' Aluminum Shed Miniature Folding Trellis 12' Wishing Well 10' x 16' Wood Barn Milligan's Superior Trellis 10' x 8' Aluminum Shed 8' x 6' Aluminum Shed 3' x 7' Picnic Table 8' x 10' Picnic Table 10' x 14' Aluminum Shed 8' x 10' Wood Barn Unit Sales Unit Cost Price $30.66 $45.99 $43.99 $65.99 $2,509.72 $4,700.00 $1,135.32 $1,702.99 $1,250.00 $1,400.99 $1,148.56 $1,607.99 $2,499.99 $2,999.99 $1,393.56 $1,950.99 $1,135.00 $1,350.00 $333.33 $500.00 $379.29 $505.72 $202.30 $252.87 $2,963.99 $3,430.99 $53.32 $79.99 $840.47 $1,050.59 $879.99 $950.78 $751.87 $999.99 $11.42 $15.99 $145.92 $207.56 $210.59 $350.99 $21.02 $27.99 $1,043.57 $1,304.47 $1,141.84 $1,507.24 $424.58 $620.75 $346.36 $519.59 $48.00 $54.87 $130.66 $195.99 $808.26 $1,074.99 $764.81 $899.78 $185.17 $249.99 $148.14 $199.99 $207.42 $299.99 $269.28 $399.99 $650.99 $1,200.00 $541.33 $804.49 Average On Hand Average Unit Sales/Year Cost of Average Inventory 275 201 $8,431.50 300 278 $13,197.00 2 2 $5,019.44 72 75 $81,743.04 42 75 $52,500.00 75 136 $86,142.00 71 144 $177,499.29 32 65 $44,593.92 80 175 $90,800.00 80 200 $26,666.40 14 35 $5,310.06 10 25 $2,023.00 15 39 $44,459.85 300 780 $15,996.00 75 202 $63,035.25 114 325 $100,318.86 48 140 $36,089.76 237 702 $2,706.54 12 42 $1,751.04 44 157 $9,265.96 230 845 $4,834.60 80 302 $83,485.60 12 50 $13,702.08 50 215 $21,229.00 50 241 $17,318.00 20 100 $960.00 25 147 $3,266.50 10 67 $8,082.60 1 7 $764.81 50 400 $9,258.50 48 475 $7,110.72 77 850 $15,971.34 26 299 $7,001.28 20 $13,019.80 50 700 $27,066.50 Annual Sales $9,243.99 $18,345.22 $9,400.00 $127,724.25 $105,074.25 $218,686.64 $431,998.56 $126,814.35 $236,250.00 $100,000.00 $17,700.20 $6,321.75 $133,808.61 $62,392.20 $212,219.18 $309,003.50 $139,998.60 $11,224.98 $8,717.52 $55,105.43 $23,651.55 $393,949.94 $75,362.00 $133,461.25 $125,221.19 $5,487.00 $28,810.53 $72,024.33 $6,298.46 $99,996.00 $94,995.25 $254.991.50 $119,597.01 $300,000.00 $563, 143.00 Cost of Goods Sold Annual Gross Profit $6,162.66 $3,081.33 $12,229.22 $6,116.00 $5,019.44 $4,380.56 $85,149.00 $42,575.25 $93,750.00 $11,324.25 $156,204.16 $62,482.48 $359,998.56 $72,000.00 $90,581.40 $36,232.95 $198,625.00 $37,625.00 $66,666.00 $33,334.00 $13,275.15 $4,425.05 $5,057.50 $1,264.25 $115,595.61 $18,213.00 $41,589.60 $20,802.60 $169,774.94 $42,444.24 $285,996.75 $23,006.75 $105,261.80 $34,736.80 $8,016.84 $3,208.14 $6,128.64 $2,588.88 $33,062.63 $22,042.80 $17,761.90 $5,889.65 $315,158.14 $78,791.80 $57,092.00 $18,270.00 $91,284.70 $42,176.55 $83,472.76 $41,748.43 $4,800.00 $687.00 $19,207.02 $9,603.51 $54,153.42 $17,870.91 $5,353.67 $944.79 $74,068.00 $25,928.00 $70,366.50 $24,628.75 $176,307.00 $78,684.50 $80,514.72 $39,082.29 $162,747.50 $137,252.50 $378,931.00 $184,212.00 Gross Margin Ratio Markup Percentage Inventory turnover Days in Inventory 33.33% 50.00% 1 499 33.34% 50.01% 1 394 46.60% 87.27% 1 365 33.33% 50.00% 1 350 10.78% 12.08% 2 204 28.57% 40.00% 2 201 16.67% 20.00% 2 180 28.57% 40.00% 2 180 15.93% 18.94% 2 167 33.33% 50.00% 3 146 25.00% 33.33% 3 146 20.00% 25.00% 3 146 13.61% 15.76% 3 33.34% 50.02% 3 140 20.00% 25.00% 3 136 7.45% 8.04% 3 128 24.81% 33.00% 3 125 28.58% 40.02% 3 123 29.70% 42.24% 4 104 40.00% 66.67% 4 102 24.90% 33.16% 4 99 20.00% 25.00% 4 97 24.24% 32.00% 4 88 31.60% 46.20% 4 85 33.34% 50.01% 5 76 12.52% 14.31% 5 73 33.33% 50.00% 6 62 24.81% 33.00% 7 54 15.00% 17.65% 7 52 25.93% 35.01% 8 46 25.93% 35.00% 10 37 30.86% 44.63% 11 33 32.68% 48.54% 12 32 45.75% 84.33% 13 29 32.71% 48.61% 14 26 250 37 38 39 40 41 42 43 44 Total 45 Average 46 Min 47 Max 48 $1,100,620.24 $31,446.29 $764.81 $177,499.29 $4,637,018.24 $132,486.24 $5,487.00 $563,143.00 $3,449,363.23 $98,553.24 $4,800.00 $378,931.00 $1,187,655.01 $33,933.00 $687.00 $184,212.00 $11.42 $2,963.99 $15.99 $4,700.00 26.76% 7.45% 46.60% 38.71% 8.04% 87.27%