Auto populate B1 based on the values ranged from A1:A8

[PAPPU]

Hi Gents

I will enter A,B,C,D,E,F,G,H from A1:A8

A,B,C,D belongs to X
E,F,G,H belongs to Y

Is it possible if I enter any of these A,B,C,D,E,F,G,H, for Eg: if I enter D in A3 , I wish to get X in B1 because A,B,C and D belongs to X ?
Similarly if any of these letter when i enter , I should get respective X or Y in cell B1

Thanks In Advance

 

[hajiali]

From what I understand your just enter data in A3 and needing to get X or Y in B1 based on Cell A3 values. if thats the case try:

Book1
	A	B
1		Y
2
3	G
Sheet1

Cell Formulas
Range	Formula
B1	B1	=IF(OR(A3="A",A3="B",A3="C",A3="D"),"X",IF(OR(A3="E",A3="F",A3="G",A3="H"),"Y",""))

otherwise please clarify

 

[My Aswer Is This]

Are you wanting a formula solution or a Vba solution?

 

[My Aswer Is This]

If you want a Vba solution then:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

When you enter the proper value in Range("A1:A8") the script will run

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  2/3/2022  11:38:39 PM  EST
If Target.Column = 1 And Target.Row < 9 Then

Select Case Target.Value
    Case "A", "B", "C", "D"
        Range("B1").Value = "X"
    Case "E", "F", "G", "H"
        Range("B1").Value = "Y"
End Select

End If
End Sub

 

[PAPPU]

Thanks all for the prompt reply,

I need a formula only, Let me please elaborate bit more

For eg: I have total of 32 person, say "1 to 32 as names" and they are divided into 4 groups

1-8 belongs to person A
9-16 belongs to person B
17-24 belongs to person C
25-32 belongs to person D

I have a table. from A1: A50 , I may enter any of these number from 1-32.

So,

If I enter 18 in cell A10 , I require C to be auto populated in cell E10
if I enter 28 in cell A10 , I require D to be auto populated in cell E10
And if i keep any of the cell from A1: A50 as empty then it should keep E1: E50 empty as well.

A short input is made and attached here.

Thanks

 

[My Aswer Is This]

OK: Thanks.
I'm good with Vba but not so much with formulas like you want.
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Fluff]

Are you actually putting names into col A or numbers?

 

[PAPPU]

Thank you for the response, In fact In column A and E , it will be names for info

 

[PAPPU]

One silly mistake. Please read as below, at earlier query Cell reference number was wrongly mentioned

If I enter 18 in cell B11 , I require C to be auto populated in cell E11
if I enter 28 in cell B11 , I require D to be auto populated in cell E11
And if i keep any of the cell from B1: B50 as empty then it should keep E1: E50 empty as well.

 

[PAPPU]

In column B and E: Names only, Thanks