60.1K

Verified Solution

Link Copied!

Hello, I need help with this tasks in Excel. Here needs to be used Vlookup and Match functions

Here are some clearer pictures

Use VLOOKUP to complete the table (D7:D11) Use VLOOKUP+MATCH in B12:E12 1 In A3:A5 create a drop-down fist of fish species avallable in the table below 2 in 83: 85 create a drop-down list of months 3 Use combination of VLOOKUP and MATCH to fill in C3:.S D 1 Using Vlookup calculate prices for every position in the order list. 2 Calculate Total Price \begin{tabular}{l} 1 Apply Data Valldation to cell (ilst) \\ 2 Use VLookUPtMATCH in 812:E12 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline ID Last & Firs & E-mall & Phone \\ \hline & & & & \\ \hline \end{tabular} 8 Uie Vigokup and Mates te thaw prite fer the salecked boomitrat model Use VLOOKUP to complete the table (D7:D11) Use VLOOKUP+MATCH in B12:E12 1 In A3:A5 create a drop-down fist of fish species avallable in the table below 2 in 83: 85 create a drop-down list of months 3 Use combination of VLOOKUP and MATCH to fill in C3:.S D 1 Using Vlookup calculate prices for every position in the order list. 2 Calculate Total Price \begin{tabular}{l} 1 Apply Data Valldation to cell (ilst) \\ 2 Use VLookUPtMATCH in 812:E12 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline ID Last & Firs & E-mall & Phone \\ \hline & & & & \\ \hline \end{tabular} 8 Uie Vigokup and Mates te thaw prite fer the salecked boomitrat model

Answer & Explanation Solved by verified expert

See Answer