** HELP ** Formula based on drop down list
Hi All,
@Hans Vogelaar/ @Sergei Baklan
I want to generate a specific value based on certain criteria being met example below
Image 1: So in this example, if the value in Cell A7 is Equal to Global Platform and Cell C7 is Equal to Launches but the value in Cell E7 is Global i want it to then look on tab Cataologue and pull back the relevant information (Image 2). so where there is a Y, YF or YA in the column for “global” it will then return the values in Column D
Image 1:
Image 2:
Hi All,@Hans Vogelaar/ @Sergei Baklan I want to generate a specific value based on certain criteria being met example belowImage 1: So in this example, if the value in Cell A7 is Equal to Global Platform and Cell C7 is Equal to Launches but the value in Cell E7 is Global i want it to then look on tab Cataologue and pull back the relevant information (Image 2). so where there is a Y, YF or YA in the column for “global” it will then return the values in Column DImage 1:Image 2: Read More