Compare to columns in v lookup

Closed
sachin - Sep 14, 2015 at 03:42 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Nov 24, 2015 at 12:00 PM
Hello,


hii

i want to compare to columns in v lookup..

Pls advise ...


5 replies

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Sep 15, 2015 at 11:28 AM
Hi Sachin,

What is the issue you are experiencing?

Can't you work out the syntaxis?

Best regards,
Trowa
0
BASE SHEET OUTPUT
ARTICLE SHADE QTY ARTICLE SHADE QTY
A067 AW VLOOKUP A067 AW 10
AWN AWN 20
AB AB 5
B015 AW B015 AW 50
AWN AWN 60
AB AB 15
A079 AW A079 AW 10
AWN AWN 30
AB AB 5
A056 AW A056 AW 30
AWN AWN 50
AB AB 80
0
SACHiN > sachin
Sep 30, 2015 at 03:11 AM
k...

now i am giving some data...

JUST PUT THE QTY VAI VLOOKUP in the below details.



article shade qty article shade qty

A067 AW vlookup A067 AW 10

A067 AB vlookup A067 AB 20

A067 AWN vlooKup A067 AWN 33

B015 P510 Vlookup B015 P510 55



NOTE: pls give email link i am sending you actual data...



Kind & Regards


SACHiN
0
SACHiN > SACHiN
Oct 3, 2015 at 06:29 AM
pls reply.....
0
SACHiN > SACHiN
Oct 7, 2015 at 01:46 AM
Dear Sir

Requested to pls give another mail LiNK because i am tired to update work file...

PLEASE DO THE NEEDFUL HELP

Regards

SACHiN
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Oct 8, 2015 at 10:50 AM
Hi Sachin,

I guess you missed my post:

Post workbook by using a file sharing site like www.speedyshare.com or ge.tt and post back the download link.

Best regards,
Trowa
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Sep 28, 2015 at 11:50 AM
Hi Sachin,

Not sure if I follow you, but it looks like all the same data is on the same row.

formula in C2: =F2

Best regards,
Trowa

PS. Please stop shouting (the use of capitals).
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Oct 5, 2015 at 11:17 AM
Hi Sachin,

Still don't follow. I'll kindly await your workbook.

Post workbook by using a file sharing site like www.speedyshare.com or ge.tt and post back the download link.

Best regards,
Trowa
0
Respected sir

As per your Previous post i can not able to send my work file as per your Link.(spreadsheet & ge.it)

so i will requests to give me another link...
0
Respected Sir

Still i am waiting your response because already i have send my work file
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Oct 29, 2015 at 11:56 AM
Hi Sachin,

You may have uploaded your file, but didn't post back the download link.

Without it, I can't access your file.

Best regards,
Trowa
0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Oct 15, 2015 at 10:46 AM
Hi Sachin,

That is strange.

Let me provide you with clickable links:
http://ge.tt/
or
https://authentification.site

If one doesn't work for you, you can try the other.

Don't forget to post back the download link.

Best regards,
Trowa
0

Didn't find the answer you are looking for?

Ask a question
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Nov 24, 2015 at 12:00 PM
Go to the suggested site and follow instructions.

For www.speedyshare.com, click here to open explorer and select your file:


You will see your selected file above the Upload button, click the Upload button:


Now you have uploaded your file and now you have to let me know where to download it by copying the blue line and paste it in your next post:


Good luck and best regards,
Trowa
0