I am doing my best to write formulas, but I am still super new to it all. I am doing my best to figure out how they work and I am stuck at the moment.

I am looking for a formula that can reference cells A1:A on my main sheet, and reference another sheet (for this we will call the referenced sheet "Data Import") for the same value to exist in cells C1:C and populate with the values on the same row of that existing value (A1:A from source sheet, matching C1:C of Data Import) in cells L1:L of the Data Import sheet. Ideally, this will generate a list of all the items that match A1:A with the corresponding data from L1:L in "Data Import" that is in row with the information on C1:C of "Data Import" that matches A1:A from the main sheet.

I am stuck and really failing with trying to piece this together. The formula I tried to write is:

=If($A$1:$A="'Data Import!$C$1:$C,vlookup('Data Import'!$L$1:$L,2,false),"")")

This does yield an "#N/A" on result. I am sure this formula is not what I need, but I don't know what else to try.

Here is a link to example reference sheet that can be edited... sorry for not including that! https://docs.google.com/spreadsheets/d/10gYx08Ei0_EV0NHfQAcu-8T8_y5PrI8Egeweztw8ymQ/edit?usp=sharing

  • Please share a publicly editable sample spreadsheet with realistic-looking data. – doubleunary Apr 19 at 19:16
  • Welcome. It isn't essential that you include a spreadsheet; it would be just as useful if you added the sample data (AND the answer that you are expecting to get) in your question. – Tedinoz Apr 20 at 6:56
  • vlookup('Data Import'!$L$1:$L,2,false) This is going to generate an error. VLOOKUP` requires 4 arguments but you have only included three. – Tedinoz Apr 20 at 7:05
  • I have updated the post to include a link to an example sheet with data in cells describing exactly what I am looking at. in Sheet 2, I am looking to pull data into column B for all corresponding Store Numbers in column A to matching store number on 'Data Import' matching data in column L. – Ryan Jeffery Apr 20 at 17:33
  • Hello All - still no progress on my end, but the search continues. I fear I am just not great at understanding the language of the formulas to make them work the way I need to. – Ryan Jeffery Apr 21 at 12:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.