LinkBack URL
About LinkBacks
please help me in rectifying formula
=QUERY(Database!A1:M,"Select * where 1=1, "&IF(B2="Company Name","","&B2&"),1)
it is returning #Value
how to make this formula work
please help me in rectifying formula
=QUERY(Database!A1:M,"Select * where 1=1, "&IF(B2="Company Name","","&B2&"),1)
it is returning #Value
how to make this formula work
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
alright
Ok
Last edited by Afsheen; 12-05-2023 at 03:27 PM.
i got a solution with vlookup
Thank u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks