Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - IS and VLOOOKUP function
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
ms excel training - IS and VLOOOKUP function
Resolved · Low Priority · Version Standard
Reply Mon 10 Sep 2007, 11:58Delegate Andy said...
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?
For upcoming training course dates see: Pricing & availability
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 microsofttraining.net for my attention.
Thanks
Amanda McKee
|