|I had 2 data file with one sheet each with about 20-30 column. so were duplicated. Let say in file 1 sheet1 contain field name as A1, B1, C1, D1, ..... K1. and file 2 sheet 2 contain a1, b1, c1, d1, ....p1.|
I would want to find a value from sheet 2 in column n. and input into column G of file 1 sheet1 of the correspondance row when the value of A, B and C are all match with a, b and c.(closed match of each).
row File 1 sheet 1 file 2 sheet 2
A, B, C, D, ... G, .. K a, b, c, d, ..., n , .......p.
2 aa 15 0 NP ae 21 5 4
3 ac 18 2 #NA ac 18 9 70
4 ae 21 5 4 aa 15 0 NP
As in the above example, G2 is inputed with value from n2 when A2 match a2 and B2 match b2 and C2 match c2. and G3 is not inputed as can not find all 3 matches. and G4 is inputed as match had been found in row 2.
Kindly please let me know how to do it with the formulas. Thank you.