How to vlookup product and its qty from another sheet

[devawad]

Dear All,

I have data in which year wise, product wise sale qty is mentioned,in my sheet 1213P I want to vlookup sum of saleqty and APR from sheet 1314P
when I tried it giving #N/A error plz help.

Attached sheet for your reference.


Mahadev.

[shukla.ankur281190]

#N/A means Not available, if searchable product is not in second sheet how will you expect any result.

If you are expected any result please speak what is your criteria and expected result.

[devawad]

Dear Ankur sir,

It is giving #N/A error even if item and item sale qty is available,I want in my sheet 1213P sum of saleqty and APR from sheet 1314P for each item on
sheet 1213P.

Plz guide on the same.

Regards,
Dev.

[shukla.ankur281190]

Can you upload same excel here for checking purpose.

[devawad]

Dear Sir,

File uploaded....

Regards,

Dev

[shukla.ankur281190]

Where you are getting #N/a you expected outcome need to mention in attached excel file.

[devawad]

Uploaded new file with error

[shukla.ankur281190]

You haven't lock the range

Try

F3

Please Login or Register  to view this content.

See the highlighted part

[Glenn Kennedy]

all you have done is attached the same file, with no formulae!!!

So, try, in F3, copied down:
=VLOOKUP($A3,'1314P'!$A$5:$E$252,3,FALSE)

and in G3, copied down:
=VLOOKUP($A3,'1314P'!$A$5:$E$252,5,FALSE)

This DOES return some #N/A errors, because (in the case of the 3 that I checked) there are NO MATCHING VALUES on the 13/14 sheet. If you want to hide the uggly error message, use:

=IFERROR(VLOOKUP($A3,'1314P'!$A$5:$E$252,3,FALSE)),"")

[Glenn Kennedy]

Now I see the file with the formulae (3 attempts to get a proper sample file!!!)

It still returns some #N/A errors, so see my post above.

[devawad]

Ankur Sir,

I did the same you suugetion you given but result is same,

Kindly guide,


Dev

[Glenn Kennedy]

Devawad, Have you read post 9????

[devawad]

Dear Glenn,

First of all thanks for your help for giving your valuable time and effort, Yes I read that and tried last option given by you,Also tried by copying your formula as it is to my sheet but formula didn't work.am a beginner may be I am doing something wrong.



Thanks and regards,
Dev.

[Glenn Kennedy]

So, here is my formula (removing the #N/A errors, replacing them with blanks, EXACTLY as shown in Post 9). There are some gaps in the results (e.g. row 100). But as has been pointed out by Shukla and myself, this is because the values don't exist on 13/14 sheet.

[devawad]

Dear Glenn sir,

Yes now it is like I want, great sir, thank you so much.

Thanks and regards,
Dev.

[Glenn Kennedy]

You're welcome and thanks for the rep.