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. Commented 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 Commented 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 Commented 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 Commented Feb 5, 2021 at 12:42
  • 1
    Good work Hassan :) Commented Feb 5, 2021 at 13:23

1 Answer 1

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 and acknowledge you have read our privacy policy.

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