How to search and compare data from different sheets in Google Sheets?

Question

Google Sheets

Hello. Can you please help me solve this problem in Google Sheets?

There are 2 sheets.

I need to do the following search:

(first line - headers)

From the PAYMENT sheet, take the value of D2 (mail) and H2 (cost).

Search for the value D2 in column D of the MEET sheet.

If there is a match, then check if the value of cell H2 of the PAYMENT sheet matches the value of cell K2 of the MEETING sheet (there is a nuance - there are identical values ​​in column D, opposite which there are different values ​​in column H. That is, you need to find all the values ​​from column D and check them separately?)

If there is a match, then write the value of cell F2 of the MEETING sheet into cell C2 of the PAYMENT sheet.

What is the best way to do this?

Answer 1

You will be helped by MATCH () or VLOOKUP () for searching and INDIRECT () for generating cell address
GoogleSheets still has FILTER (), it will be more powerful than VLOOKUP ()