0

I have seen this question in similar posts, but I can't get it to work. When I select the product in the drop down in column B, I want it to populate the unit price in column F. If no selection in column B, I want column F to be blank.

Here is the link to the sample: https://docs.google.com/spreadsheets/d/19NXcbXUUaqCm6gIbXeD4vuAr_TBS0X-DWs6JMv2hASg/edit?usp=sharing

Improve this question
1
  • Welcome to [webappss.se]. While a link to an external resource might be helpful questions should be self-constained, in other words please add more details about what you tried directly into the question body.
    – Rubén - Volunteer Moderator - ♦
    Commented Nov 30, 2021 at 5:07

1 Answer 1

Reset to default
0

Use iferror() and the correct search_key range reference, like this:

=iferror( vlookup(B19, Data!A$2:B, columns(Data!A$2:B), false) )

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.