Vlookup(Query(Importrange Looking for a Formula

[shabby01]

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

[maniacb]

An example sheet, as per the yellow banner, wouldbe very helpful

[shabby01]

Trying to add the link but its not getting add.

[alansidman]

Read the Yellow Banner at the top of the page on how to upload.

[shabby01]

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.

[alansidman]

You do not have enough postings to upload links. Please read the yellow banner again and upload a file, not links.

[shabby01]

Where to find the post #4.