Current location - Loan Platform Complete Network - Local tax - How to make the previous cell display the corresponding name after inputting a number in excel?
How to make the previous cell display the corresponding name after inputting a number in excel?
The method comprises the following steps:

1. First, establish a corresponding table containing all "some numbers" and all "names" on another worksheet (such as sheet2), with data in columns A and B respectively.

2. Enter the formula = if (and (a 1

Related articles
  • Which is more difficult, tax accountant or note meeting? How to choose?
  • How the Discipline Inspection Commission strengthens the self-development of discipline inspection and supervision cadres
  • Ningxia people's story of the Ming Dynasty 56: Husha Lake, also experienced bonfires and Jinge iron horses.
  • What are the regulatory laws and regulations for Internet finance?
  • How to choose the digital currency license of the exchange?
  • Chief clerk, which level is higher, level one, level two, level three or level four?
  • What information do you need to issue a tax bill?
  • How to calculate the tax basis of stamp duty?
  • What kind of accounting treatment should enterprises do when transferring uncollectible accounts receivable?
  • Notice of the People's Government of Guangxi Zhuang Autonomous Region on printing and distributing the detailed rules for the implementation of the provisional regulations on livestock transaction tax

    • copyright 2024 Loan Platform Complete Network All rights reserved