Andy has attended:
Excel Intermediate course
Excel Advanced course
IS and VLOOOKUP function
I have two worksheets,
First one is fixed with store names, store numbers and store types... prob around 800 stores
Second one i got it from pivot table with store names and store numbers BUT doesn't hv store types... this stores list in this worksheet is change every week.. so i wanna add store type from other worksheet automatically...
someone told me that i can do it with combining 3 functions (IF, ISNA & VLOOKUP) but i don't know how to do it... can someone help me?
RE: IS and VLOOOKUP function
Hi Andy
Thanks for your question.
Sorry about the delay in replying.
If this is still an issue for you, it might be easiest for us to have a go at resolving it if you're able to email a sample of the file to us (within 'dummy' or a reduced amount of data).
If you're able to do this, please email to forum at stl-training.co.uk for my attention.
Thanks
Amanda McKee
