LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default VLOOKUP AND N/A ERRORS

I am trying to enter a formula into cell that included the VLOOKUP function
and I keep getting an N/A error as my result. Why would it do this, and what
can I do to ensure I don't keep getting it?

I am in worksheet and I am basically trying to reference another worksheet
for some of the values. I enter C3 as my lookup value (in existing sheet); I
enter a range reference (from another worksheet) as my table array; I enter
the number 2 because that is column (from the another worksheet) that I want
to use; finally, I enter FALSE because I want to return an exact match). I
also have to multiply the lookup value by C4 (in existing sheet).

Any advise is greatly appreciated. Thanks.
Amy
--
Amy Howell
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 returning Errors (ISNA formula) Nora[_2_] Excel Worksheet Functions 3 January 3rd 08 04:29 PM
VLOOKUP returning errors Dave F Excel Worksheet Functions 4 September 6th 06 06:35 PM
vlookup, but ignore errors if #n/a Jess Excel Worksheet Functions 3 August 24th 05 09:04 PM
VLookup Errors Erika Excel Worksheet Functions 4 May 20th 05 01:25 AM
errors using Vlookup BLW Excel Worksheet Functions 1 May 19th 05 06:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"