Data need to auto reflect from main sheet to subsheet

Options

Hi,

I have data in in mainsheet in text format i,e (green -5, blue-4, black-5), In subsheet if i give green , blue or black numbers has to reflect from mainsheet. I have tried with vlookup function but it is showing colour wise.... plz help me if we have any alternative in smartsheet.

Thanks in advance

Answers