ms excel training - IS and VLOOOKUP function

Resolved · Low Priority · Version Standard

IS and VLOOOKUP function

Andy has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Andy [3 posts] (2007 Sep 10 Mon, 11:58) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 2 Tue	Bloomsbury	0	FULL
2003	2008 Dec 4 Thu	Bayswater	3	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	3	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
Full Schedule: See all 110 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: IS and VLOOOKUP function

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 2 Tue, 10:36) Reply

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