hello there,
finding this forum super helpful, really appreciate everyone's assistance. I have another problem which I would really appreciate some help on
document attached for further clarity.
in [Sheet1] i'm looking to use the values in column A to look at the values in [data] and then provide the corresponding values in a drop down... for example, if Cooktop Type appears in [Sheet1] cell A1, then in [Sheet] cell B1 I'd like a drop down to show "induction" or "other", another example would be if in [Sheet1] cell A5 showed 'Diopter' then in B5 I'd like a drop down showing the options "'1" and "'1.5" as shown in the [data] sheet.
I hope this all makes sense, I'd really appreciate any help that can be provided!
thanks
Bookmarks