excel xp training - Vlookup

The UK's most regular instructor-led training courses.
Training information: excel xp training · Excel course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Vlookup

Jennifer has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Jennifer [1 post] (2006 Nov 28 Tue, 12:37) Reply

What reason is there that my vlookup finds some data but not others? Could this be something to do with cell formatting?

Thanks!

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Vlookup

by - trainer Amanda platinum contributer [968 posts] (2006 Nov 28 Tue, 13:08) Reply

Hi Jennifer

Do you get any error messages coming up in your spreadsheet in the cells where the Vlookup is not working properly?

Perhaps if you could provide a bit more information about your problem we might be able to solve it.

thanks
Amanda

RE: Vlookup

by - delegate Louise [9 posts] (2006 Nov 28 Tue, 17:29) Reply

I think that you may get the wrong results by not having the last (optional) part of the formula that allows the table to be in ANY order rather than strict numerical/alphabetical. Without it, it will find the first/closest match then stop.

· Crazy Things People Have Done With Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· How to Create Better Excel Spreadsheets: Part One
· Advanced Excel Training - takes you to the next level

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips