Code:
Hi Team,
I am looking for a formula in B3, Such a that if I found a Cell value (Gold or Silver)
in Cell A3, then I want the answer Best in Column (b3).
Else dont change any value in B3. Then i want to drag the formula till last cell value.
Through Filtering I can get the result, I am looking for a formula as a replacement for Filtering.
[TABLE="width: 128"]
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: #E26B0A"][B][FONT=Calibri][SIZE=3][COLOR=#000000]A[/COLOR][/SIZE][/FONT][/B][/TD]
[TD="width: 64, bgcolor: #E26B0A"][B][FONT=Calibri][SIZE=3][COLOR=#000000]B[/COLOR][/SIZE][/FONT][/B][/TD]
[/TR]
[TR]
[TD="bgcolor: #76933C"][FONT=Calibri][SIZE=3][COLOR=#000000]Product[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: #76933C"][FONT=Calibri][SIZE=3][COLOR=#000000]Status[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]Gold[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]BEST[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]alsk[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]Old data [/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]Silver[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]BEST[/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000]safdsa[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: transparent"][FONT=Calibri][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT][/TD]
[/TR]
[TR]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]Gold[/COLOR][/SIZE][/FONT][/TD]
[TD="bgcolor: #FABF8F"][FONT=Calibri][SIZE=3][COLOR=#000000]BETS[/COLOR][/SIZE][/FONT][/TD]
[/TR]
</tbody>[/TABLE]
<strike></strike>
Regards
Mallesh