Forum Discussion
How to LookUp a Value based on 1 drop down and 1 criteria from a different worksheet with 2 columns
I am trying to find the correct formula with the following details: On Sheet 1, I want to find what the price should be, based on 2 things: 1. Sheet 1 - A drop down with 2 options ("Roanoke"...
Also, Sheet2 isn't a table. I don't know if that matters.
Hi. It should work well whether D29 is a text or a number. It is best to share a sample workbook.
- I don't know how to do that on this forum.