Constellation formula avatar _ Constellation formula chart

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

Excel uses A 1 reference style by default, and reference letters identify columns (256 columns from A to IV; Note: the maximum number of columns is different for different versions) and the number identifying the row (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.