Im trying to create a dropdown list on a sheet, that looks up a matched value in another sheet. In the picture below is of a sheet called
PricesforCSV. Here I want the circled value in column B to be value pulled from a second sheet called
As you can see, so far I have the dropdown using working using data validation. It is defined as so:
invoiceLookup which as the information I want to look up is below. Column E has the pricing I want to bring across.
In the circled cell in Column B of
PricesforCSV I am trying to perform the lookup based on the value of the dropdown. Here is the formula Im using so far for this cell:
This is currently returning false.
The idea here is to search all of the rows in
invoiceLookup!D2:D300 looking for a match to the value in
A3, and if it is found, populate the cell with the related value in the next column:
- Im not sure this is the best approach, could I be using a two column named list, and get the values from this?
- There may be an issue with whitespace in the items from the dropdown list, though trying values that have no whitespace currently doesn't solve the problem.
Thanks for taking the time to look at this!