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


Tried Google:

Searched for your text. 


Tried Bing Chatbot:

Here are the steps to follow:

Open both sheets.
In sheet1 cell K2, enter the following formula:
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.