Forum Discussion

Hanneke_Mason's avatar
Hanneke_Mason
Copper Contributor
Apr 02, 2023

formula please help

I have two sheets

find the value that is in sheet1 cell a2 (for example A2 has 176) on sheet 2 in column A (look through the whole column for 176) if 176 is found return the value of that row col L to sheet 1 col k

 

 

 

Formulas and Functions

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 02, 2023

    Hanneke_Mason 

    Tried Google:

    Searched for your text. 

     

    Tried Bing Chatbot:

    Here are the steps to follow:

    1.
    Open both sheets.
    2.
    In sheet1 cell K2, enter the following formula:
    =IFERROR(VLOOKUP(A2,Sheet2!A:L,12,FALSE),"")
    3.
    Copy the formula down to all other cells in column K that you want to apply this formula to.

    This formula will look for the value in sheet1 cell A2 in column A of sheet2. If it finds the value, it will return the value in column L of that row. If it doesn't find the value, it will return an empty string.

    I hope this helps! Let me know if you have any other questions.

     

Resources