Excel help

[Maranda]

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?

 

[Logit]

.

=VLOOKUP(B3,RentalAmount,4,FALSE)

Download workbook : https://www.amazon.com/clouddrive/share/YfubqtPgrzkL3Rfq9uoFBK1vWyyTQajI7sJVung1Ti

 

[ravishankar]

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