formula please help

Copper Contributor

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

 

 

 

1 Reply

@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.