Excel Question

Melissa K
Melissa K used Ask the Experts™
on
I need the formula for Excel that if one cell on sheet one is equal to one cell on sheet two, then insert a sheet two value into a cell on sheet one.

Example: If B2 (sheet1) is equal to C2(Sheet2) then insert C3(sheet 2) into B3(sheet1)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
On Sheet1
In B3
=IF(B2=Sheet2!C2,Sheet2!C3,"")

Open in new window

Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
The chosen answer resolved the question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial