IF Statement Not Working Across Sheets

**Sam Capricci** · 01-23-2019, 04:23 PM

I'm not sure how your first one works =IF(A180:A181=A180,IF(B180:B181=B180,C180)) as I copied it and put it in sheet1 and it returned value.
is this what you are looking for?
=IF(OR(Sheet1!A180=Sheet2!B1,Sheet1!A181=Sheet2!B1,Sheet1!B180=Sheet2!A2,Sheet1!B181=Sheet2!A2),Sheet1!C180,"")
BTW, you wrote

If Column A states "RF Module 1" and 2, If Column B states "RF Drive Power" to pull Column C.

But when I look at what is across from RF module 1 and RF drive power it isn't 6.3, it is 2575.9833.

**bdenn** · 01-23-2019, 05:04 PM

Hello,
That formula did not seem to work.

I have redone my example to try and get better results. I'm looking for a formula that will check all of column A and all of column B
in sheet 1 and if they match the row and column in sheet 2 then input the data from column C in sheet 1 to sheet 2.

Attached is another document with detailed notes.

Thanks,
Bdenn