- In the Cabin Rentals worksheet, Michael created an area for retrieving information from the range Cabin_Rentals. In cell M11, enter a formula using the VLOOKUP function to retrieve the renters name as follows:
- Look up the value in cell M10.
- Use Cabin_Rentals as the table_array argument.
- Return the corresponding renters name shown in column 2 of the table array.
- Use FALSE as the range_lookup value to find an exact match.
What would be --"Return the corresponding renters name shown in column 2 of the table array."
Its confusing!
Also, I need A12 - J12 to start at A11- J11 - can't shift it with 'Shift +Alt + top arrow"
fx M11 B K Criteria Range 5 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Mountain View Weekly Rate Kitchen >2 YES Rental Lookup Cabin Rentals 10 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen Mountain View Weekly Rate Cabin ID 125 Renter 12 103 McCarthy Weeks Rente Peter 1/6/2019 2 YES NO 2000 13 YES Revenue 104 Bowen Mary Dell 1/6/2019 YES 2300 3 14 110 Green 1/7/2019 Rashad NO YES 1800 15 YES 112 Chambers lan 1/8/2019 2 2 NO 1700 16 115 Yang Kim 1/9/2019 4 YES YES 1750 17 2800 120 Tollitts one 1/10/2019 3 8 YES YES 18 122 Jaspers 1500 Katherine 1/11/2019 1 NO YES 19 125 Rizzo John 1/11/2019 YES NO 1475 20 YES 2500 130 Cruz Natalie 1/12/2019 3 10 21 131 Washington Devon 1/12/2019 3 8 YES YES 2500 22 23 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen Mountain View Weekly Rate 24 Final Figure 8: Cabin Rentals Worksheet G Adela Mountain Resort Cabin Rentals 3 Criteria Range Mountain View Weekly Rate 5 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen >2 YES Cabin Rentals Rental Lookup 10 Cabin ID Kitchen Mountain View Weekly Rate Last Name First Name Start Date Bedrooms Bathrooms Sleeps Cabin ID 125 Peter 1/6/2019 103 McCarthy 6. YES NO 2000 Renter Rizzo 12 Weeks Rented 104 Bowen 1/6/2019 3 YES 2300 Mary Dell YES 110 Green 1/7/2019 13 Rashad NO YES 1800 Revenue $4 2,950 14 112 Chambers lan 1/8/2019 2 YES NO 1700 115 Yang 15 Kim 1/9/2019 YES YES 1750 16 one 120 Tollitts I/10/2019 3 3 8. YES YES 2800 17 122 Jaspers Katherine I/I1/2019 3 NO YES 1500 125 Rizzo 18 John I/L1/2019 YES NO 1475 19 130 Cruz Natalie /12/2019 3 3 10 YES NO 2500 20 131 Washington Devon I/12/2019 3 8. YES YES 2500 21 Extract Area 22 23 Cabin ID First Name Start Date Kitchen Mountain View Weekly Rate Last Name Bedrooms Bathrooms Sleeps YES 104 Bowen Mary Dell 1/6/2019 24 3 YES 2300 25 120 Tollitts Tyrone I/10/2019 YES 2800 3 3 YES 130 Cruz 26 Natalie I/12/2019 3 10 YES NO 2500 131 Washington 2500 27 Devon I/12/2019 3 2 YES YES 28 29 Pinehill Lodge Total Revenue Chart All Locations Cabin Rentals New Inn *** fx M11 B K Criteria Range 5 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Mountain View Weekly Rate Kitchen >2 YES Rental Lookup Cabin Rentals 10 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen Mountain View Weekly Rate Cabin ID 125 Renter 12 103 McCarthy Weeks Rente Peter 1/6/2019 2 YES NO 2000 13 YES Revenue 104 Bowen Mary Dell 1/6/2019 YES 2300 3 14 110 Green 1/7/2019 Rashad NO YES 1800 15 YES 112 Chambers lan 1/8/2019 2 2 NO 1700 16 115 Yang Kim 1/9/2019 4 YES YES 1750 17 2800 120 Tollitts one 1/10/2019 3 8 YES YES 18 122 Jaspers 1500 Katherine 1/11/2019 1 NO YES 19 125 Rizzo John 1/11/2019 YES NO 1475 20 YES 2500 130 Cruz Natalie 1/12/2019 3 10 21 131 Washington Devon 1/12/2019 3 8 YES YES 2500 22 23 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen Mountain View Weekly Rate 24 Final Figure 8: Cabin Rentals Worksheet G Adela Mountain Resort Cabin Rentals 3 Criteria Range Mountain View Weekly Rate 5 Cabin ID Last Name First Name Start Date Bedrooms Bathrooms Sleeps Kitchen >2 YES Cabin Rentals Rental Lookup 10 Cabin ID Kitchen Mountain View Weekly Rate Last Name First Name Start Date Bedrooms Bathrooms Sleeps Cabin ID 125 Peter 1/6/2019 103 McCarthy 6. YES NO 2000 Renter Rizzo 12 Weeks Rented 104 Bowen 1/6/2019 3 YES 2300 Mary Dell YES 110 Green 1/7/2019 13 Rashad NO YES 1800 Revenue $4 2,950 14 112 Chambers lan 1/8/2019 2 YES NO 1700 115 Yang 15 Kim 1/9/2019 YES YES 1750 16 one 120 Tollitts I/10/2019 3 3 8. YES YES 2800 17 122 Jaspers Katherine I/I1/2019 3 NO YES 1500 125 Rizzo 18 John I/L1/2019 YES NO 1475 19 130 Cruz Natalie /12/2019 3 3 10 YES NO 2500 20 131 Washington Devon I/12/2019 3 8. YES YES 2500 21 Extract Area 22 23 Cabin ID First Name Start Date Kitchen Mountain View Weekly Rate Last Name Bedrooms Bathrooms Sleeps YES 104 Bowen Mary Dell 1/6/2019 24 3 YES 2300 25 120 Tollitts Tyrone I/10/2019 YES 2800 3 3 YES 130 Cruz 26 Natalie I/12/2019 3 10 YES NO 2500 131 Washington 2500 27 Devon I/12/2019 3 2 YES YES 28 29 Pinehill Lodge Total Revenue Chart All Locations Cabin Rentals New Inn ***
