Forum Discussion
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 ...
Tried Google:
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.