0

https://docs.google.com/spreadsheets/d/1kYkfBoDsJR-sBo5J52lJTXKa-EXoFYPgVPnrRGvOx5A/edit?usp=sharing

=query(Importrange("1kYkfBoDsJR-sBo5J52lJTXKa-EXoFYPgVPnrRGvOx5A","LastRevision!A5:Y"),"Select * where Col3 = '"&B28&"'",1) What is wrong with '"&B28&"' instead of just typing the number. Why its showing error.. '"&B28&"' contains a number which I want to match with the reference column. If I just type the number it works well, but referring to the cell that has the number doesn't work.

5
  • This is the answer you are looking for. – marikamitsos Feb 5 at 9:16
  • For me it didn't work probably because the cell contains this ='CASES LIST'!C6 and C6 is the number of day in another sheet and its date in "d" format – Hassan Almaateeq Feb 5 at 12:04
  • Select * Where Col3= date ' "&TEXT('CASES LIST'!C6,"d")&" ' ",0) where 'Cases List'C6 is Date in "dd-mm-yyyy". And I need the "d" only – Hassan Almaateeq Feb 5 at 12:26
  • 1
    Ok. I got it. first I have to convert that into a text in another cell =TEXT('CASES LIST'!C6,"D") then use this cell as reference.. Thanks – Hassan Almaateeq Feb 5 at 12:42
  • 1
    Good work Hassan :) – marikamitsos Feb 5 at 13:23
0

Ok. I got it. first I have to convert that into a text in another cell =TEXT('CASES LIST'!C6,"D") then use this cell as reference.. Thanks

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.