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 invoiceLookup
:
As you can see, so far I have the dropdown using working using data validation. It is defined as so: =invoiceLookup!$D:$D
,
The sheet 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:
=IF(ISNA(VLOOKUP(A3,invoiceLookup!D2:D300,2,0)),
VLOOKUP(A3,invoiceLookup!E2:E300,2,0))
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: invoiceLookup!E2:E300
.
- 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!