Formula to get the results similar to excel by linking to cells in if & vlookup

[Suresh]

Hi Experts,

I need some guidance to find a formula similar to excel approach where i can link 2 cells in table1 of file1 to get the data from another table which is in different file2.

In table 1 i have data Key1 in column format A/B/C and key2 in row format x/y/z but in Table2 we have both Key1 & Key2 in column format so i am using easy option to combine key1&key2 as Combo in Table2 and in table1 i am using below formula to get the results as Yes/No.

=IF(VLOOKUP(A2&B$1,H:H,1,0)=A2&B$1,"Yes","No") in column B,C & D

2 Tables of data:

Thanks for your time

Regards

Suresh

[atcodedog05]

Hi @Suresh 

Can you provide some sample input file and expected output file It will help us get a better understanding of the usecase.

We will be happy to help : )

[Suresh]

This is one of the step i am doing in my use case... so trying to find a way i can get the result shown above as an example..

[atcodedog05]

Hi @Suresh 

can you provide us the excel as an attachment it will be easier for us to build the solution.

Happy to help : )

[gabrielvilella · Accepted solution]

Hi @Suresh, please always try to include the actual dataset, not just the image so we don't have to type everything manually. Here is one way of doing this.