Share via

Need a formula

Maurizio5 6 Reputation points
2023-01-05T11:20:35.53+00:00

Need a formula to find a cell with text in a worksheet and copy the numeric value to the right of that cell into another worksheet

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,956 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,979 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,173 questions
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,651 Reputation points
    2023-01-11T09:24:41.96+00:00

    Hi @Maurizio5
    I am glad that you find out the formula you need and thanks for your sharing.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.", and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    Requests:

    Need a formula to find a cell with text in "Quote " worksheet and copy the numeric value to the right of that cell into another worksheet "Retirement".

    There are 3 columns (A, D and G) include text strings to be found in "Quote".

    Besides, there are Column B, E, H contain the numeric values that can be returned.

    Capture16

    Formula:

    Using Vlookup function to find numeric values from 3 data ranges.

    IFERROR(VLOOKUP(C3,Quote!$A$2:$B$165,2,FALSE),IFERROR(VLOOKUP
    (C3,Quote!$D$2:$E$165,2,FALSE),(VLOOKUP(C3,Quote!$G$2:$H$165,2,FALSE))))

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 45,096 Reputation points
    2023-01-05T11:43:35.373+00:00

    That question is to vague, please post an example and the expected result.
    Just a note: The is no formula "find something anywhere" available in Excel.

  3. Emily Hua-MSFT 27,651 Reputation points
    2023-01-06T02:28:59.797+00:00

    Hi @Maurizio5

    Welcome to Q&A forum ~

    I would suggest you try the Vlookup function in Sheet 1, such as =VLOOKUP(C3,Sheet2!$D$2:$E$4,2,FALSE).

    276742-capture4.png

    276619-capture5.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  4. J Barrios 1 Reputation point
    2023-01-06T03:15:50.673+00:00

    Since you are essentially looking up data... Xlookup is the most versatile lookup tool in excel right now, imo. Good luck.

    276704-image.png

    276684-image.png

  5. J Barrios 1 Reputation point
    2023-01-07T06:04:05.763+00:00

    Hope this gives a little more context. (if you change the GLFOX1 on sheet1 to GLFOX2 the Formula cell will return 2.)
    277078-image.png

    277132-image.png

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.