Google sheet, wish to copy paste data from a sheet to another reference from two column

[Bhavesh780]

I need to copy paste data of column TAGS, NOTES, and SNAPSHOTS to NEW sheet, and for unique value I selected "Date" and "Price" should be match.

So for that copy data from Sheet "CSV" from column I with reference from two values matching column A and E and paste data to sheet "NEW" of column M match data from sheet "NEW" column A and G

I asked Gemini she provide this formula =INDEX(CSV!I:I, MATCH(NEW!A1:A, CSV!A1:A, 0)) but got some error probably FORMATTING ISSUES

I attached sheet for reference and provide editable link of google sheet docs.google.com/spreadsheets/d/1kt0_NPnm9MO9iioC2eZeZ0-xJeWgw1tBMLhxNsoENGI/edit?usp=sharing

Thanks

[shina67]

To achieve the desired result, you can use the following formula in cell M2 of the "NEW" sheet and drag it down:


=IFERROR(INDEX(CSV!I:I, MATCH(1, (CSV!A:A=NEW!A2)*(CSV!E:E=NEW!G2), 0)), "")

This formula will search for the first occurrence of a combination of values in column A (Date) and column E (Price) in the "CSV" sheet that matches the corresponding values in columns A (Date) and G (Price) in the "NEW" sheet. Once found, it will return the value from column I (TAGS) in the "CSV" sheet.

Make sure to replace the range references (CSV!I:I, CSV!A:A, CSV!E:E, NEW!A2, NEW!G2) with the appropriate ranges in your sheet.

Here's how you can use it:

Go to cell M2 in the "NEW" sheet.
Enter the formula provided above.
Press Enter.
Drag the formula down to fill the rest of the cells in column M.

This should copy the data from column I (TAGS) in the "CSV" sheet to column M in the "NEW" sheet based on matching values in columns A and E of "CSV" with columns A and G of "NEW".

[Bhavesh780]

I'm getting Blank cell result in sheet "NEW" you can also checkout google sheet link docs.google.com/spreadsheets/d/1kt0_NPnm9MO9iioC2eZeZ0-xJeWgw1tBMLhxNsoENGI/edit?usp=sharing

[JeteMc]

For the excel file the following array entered formula** will work for tags and notes:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
1. Select cell M2 and paste the formula into the formula bar.
2. Activate the formula as described above.
3. Drag the fill handle over to cell N2
4. While cells M2:N2 are still selected double click the fill handle to copy the formula down
If you don't want to see the zeros in columns M:N then custom format those columns using: General;;
Let us know if you have any questions.