Excel table constellation calculation formula (enter birthday calculation constellation)

{" 1/2 1 ","2/20 ","3/2 1 ","4/2 1 ","5/22 ","6/22 "and" 7/22 " "seat").

For example, the following formula

=IF(ISNA(VLOOKUP(B5，sheet 1！ $B$2:$E$ 179，2，FALSE))，""，VLOOKUP(B5，sheet 1！ $B$2:$E$ 179，2，FALSE))

X=VLOOKUP(B5，sheet 1！ $ b $2: $ e $179,2, FALSE)-> If the same condition is found, take its value. The whole thing is to find value, but I can't find it. Replace NA with blank. The formula ISNA is similar to ISERROR, but when ISERROR makes an error, it also displays a blank. For ISNA, errors will be displayed and NA will be blank.

A 1 reference style

By default, Excel uses A 1 reference style, with reference letters to identify columns (from A to IV, *** 256 columns, note: the maximum number of columns is different in different versions) and reference numbers to identify rows (from 1 to 65536). These letters and numbers are called line numbers and column labels. To refer to a cell, enter a column label and a row number. For example, B2 refers to the cell at the intersection of column B and row 2.