Question: Design a simple query application to input the Feature in B14 and Name in B15, and retrieve the corresponding personal information in B17 where index

Design a simple query application to input the

Design a simple query application to input the Feature in B14 and Name in B15, and retrieve the corresponding personal information in B17 where index and match functions need to be used. For example, when you key in Rod Filmore in B14 and Hair Color in B15, the cell B17 should return Blonde, when you type Liam Su in B14 and Height in B15, the cell B17 should return 6-4, etc. Name Feature Height Weight Sex City Hair Color Eye Color Scott Rod Sara Bill Rider Davenport Filmore Martin 5-9 5-8 6-1 5-11 158 168 194 145 M M M F New York Boston Chicago DC Brown Black Blonde Red Green Blue Brown Blue Jose Smith 5-4 123 | M LA Black Brown Jill Trainor 5-9 162 F Boise Brown Blue Liam Su 6-4 204 M Atlanta Blonde Blue Name Feature Personal Information

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 General Management Questions!