Hello. Any help is really appreciated
I tried to use vlookup but it will only show the result of 1 dropdown list
based on this video. youtube.com/ watch?v=QKcrJdFzOwE&t=354s[/url]
I want to auto populate cell based on the result of 2 drop down boxes.
on the sample file if they choose handhelds then gba green it should say "available" on the "result" column.
but if they choose handhelds then gba yellow it should autopopulate to "sold" I was able to do this however
How can you make it the same for pspgreen to autopopulate as availble then psp green as sold