Apt owners would like to be able to search thru apt numbers and return the price of apt. Listed. I need help creating a nested lookup function in cell E3. Look up rental price in column D using the apt unit number in cell B3.what would this formula look like?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Logit
Well-known Member
- Joined
- Aug 31, 2016
- Messages
- 5,046
- Office Version
- 2019
- 2007
- Platform
- Windows
.
Download workbook : https://www.amazon.com/clouddrive/share/YfubqtPgrzkL3Rfq9uoFBK1vWyyTQajI7sJVung1Ti
Code:
=VLOOKUP(B3,RentalAmount,4,FALSE)Download workbook : https://www.amazon.com/clouddrive/share/YfubqtPgrzkL3Rfq9uoFBK1vWyyTQajI7sJVung1Ti
Upvote
0
ravishankar
Well-known Member
- Joined
- Feb 23, 2006
- Messages
- 3,566
you can keep customer interface and search data on separate sheets (password protect database) and on Entering the apt no in A4, rest of the details relevant to it gets pulled. see the file in this link https://drive.google.com/open?id=1Uhvc6lspzO4N1P3Y27JRt-EdMk6OdwTY
Ravi
Ravi
Upvote
0
Similar threads
- Question
