Posted to microsoft.public.excel.worksheet.functions

Dave F

external usenet poster

Posts: 2,574

VLOOKUP returning errors

I have the following VLOOKUP formula, =VLOOKUP(A2,'July Serial
Numbers'!$A$1:$M$72,5,FALSE), which returns #N/A errors.

A2 is in a column named Asset Number, the tab July Serial Numbers has the
related serial numbers 5 columns from the left (column E). What am I doing
wrong?

--
Brevity is the soul of wit.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLookup a Vlookup	adamb2000	Excel Worksheet Functions	4	June 28th 06 10:54 PM
Vlookup returning Hyperlinks	Shannon W.	Excel Worksheet Functions	5	February 10th 06 03:46 PM
VLOOKUP not returning correct value	leigh	Excel Worksheet Functions	6	October 13th 05 12:22 PM
errors using Vlookup	BLW	Excel Worksheet Functions	1	May 19th 05 06:18 PM
vlookup returning #NA	dandigger	Excel Discussion (Misc queries)	11	April 6th 05 11:13 PM

All times are GMT +1. The time now is 09:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us