Forum Discussion

BriannaYK's avatar
BriannaYK
Copper Contributor
Nov 16, 2020

Help pulling row information from a list using IF

I'm trying to pull information from a row in a separate sheet using if to see if it meets the criteria within a column. e.g. if a cell in column A = 3, I then want it to show the information from col...
Excel
Formulas and Functions
adversi's avatar
adversi
Iron Contributor

BriannaYK 

I've recently helped someone with a similar issue that has already applied an array formula to pull relevant information into separate tabs in real-time. (Link)

 

Can you attach your workbook to get a better idea of the data?

BriannaYK's avatar
BriannaYK
Copper Contributor
Nov 16, 2020

adversi Hi, Sorry I'm not sure if I really understand the formula/discussion in the link you provided and I'm afraid I can't attach the document in question 😞 

I was hoping someone could tell me what needs to be added to my formula so that only the cell amount from the row where the condition is true, shows.

  • adversi's avatar
    adversi
    Iron Contributor
    Nov 16, 2020

    BriannaYK 

    The reason sending a template would help is to understand the data structure and best formula to apply:

     

    1. Will there be more than one row being pulled by the matched logical test?

    2. How many columns of data are in a row?

    3. What is the end goal of the workbook - will there only be one tab with final results that you want automatically updated when the condition changes?

     

    The formula will change depending on the answers of the question above, whether it a simple IF can do the job or if an array needs to be created.

Resources