I have two separate sheets with same data Col1 to Col5 and i want to get the just 6 column to other sheet after verifying the both sheets data Col1 to Col5 same as vlookup confirms.
Query(Importrange("Sheet Link","A1:F"), "Select Col6 Where Col1 ='"&A:A&"' and Col2 ='"&B:B&"' and Col4 ='"&C:C&"' and Col5 ='"&D:D&"'", 0) as Vlookup works.
any help would be highly appreciated
Last edited by shabby01; 09-04-2020 at 02:25 PM.
An example sheet, as per the yellow banner, wouldbe very helpful
Trying to add the link but its not getting add.
Read the Yellow Banner at the top of the page on how to upload.
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
Sir, i am using google sheet and trying to upload the links.
Its gives me an error to upload the links.
There i no information for uploading the links on yellow highlighted Banner.
You do not have enough postings to upload links. Please read the yellow banner again and upload a file, not links.
Where to find the post #4.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks