Forum Discussion
Solved
If Cell on Sheet 1 & 2 match, copy cell on Sheet 2 to a new cell on Sheet 1
Sheet 1 has a list of company payments. Sheet 2 has a list of companies and their main contacts. I am looking for a formula for the following statement: If the company name in column A on sheet ...
=INDEX(Sheet2!$D$2:$D$13,MATCH(Sheet1!A3,Sheet2!$A$2:$A$13,0))You can try INDEX and MATCH.
Sheet1:
Sheet2:
=INDEX(Sheet2!$D$2:$D$13,MATCH(Sheet1!A3,Sheet2!$A$2:$A$13,0))You can try INDEX and MATCH.
Sheet1:
Sheet2:
- This worked! Thank you!
