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.

Improve this question
5
  • This is the answer you are looking for.
    – marikamitsos
    Feb 5, 2021 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, 2021 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, 2021 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, 2021 at 12:42
  • 1
    Good work Hassan :)
    – marikamitsos
    Feb 5, 2021 at 13:23

1 Answer 1

Reset to default
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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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