Fortune Telling Collection - Zodiac Analysis - Design a table, enter the ID number in one cell, and immediately display the ID owner's constellation in another cell.
Design a table, enter the ID number in one cell, and immediately display the ID owner's constellation in another cell.
Build a query table:
Use the query function to query the above table to obtain constellation information, and the formula is as follows:
= iforror(VLOOKUP(VALUE(MID(D2，7，8)，" 0000-00-00 "))-DATE(YEAR(VALUE(TEXT(MID(D2，7，8)，" 0000-00-00 "))， 1， 1)，A:B，2)，"")
- Previous article:What is the birthday sign of 1997 in August 1 1
- Next article:Does the dog have a constellation _ Does the dog have a constellation?
- Related articles
- Zodiac fortune _ Zodiac fortune query
- I am not a constellation. Yes, I'm not a constellation. What song is it?
- Who do the twelve constellations like best?
- 1987 What is the constellation of the 16th day of the first lunar month?
- The constellation of blackmailing parents.
- What is the constellation on August 6th?
- What constellation do girls think is the most humorous?
- How tall is William Chan?
- Which constellation is the best match for virgins?
- I was born in 1983, on the first day of the fifth lunar month, in June of the solar calendar 1 1, at five o'clock in the morning. I want to ask about the sun sign, the moon sign and the rising sign.