Populating data from one sheet to another if fields match

[Calibre16]

Hi All,

I'm hoping someone can help here.
I want to write a formula in Sheet 1 J2 that says: If C2 Sheet1 matches with B3 Sheet2 then the number in C3 Sheet2 should populate in J2 Sheet1

Thanks,


Calibre16

 

[Brian from Maui]

Try using the IF function. Syntax is
=
IF(Logical Test,If True,If False)

So your test would be Sheet1!C2=Sheet2!B3

If True = Sheet2!C3

If False = "" (Blank)