Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup returning Errors (ISNA formula) | Excel Worksheet Functions | |||
VLOOKUP returning errors | Excel Worksheet Functions | |||
vlookup, but ignore errors if #n/a | Excel Worksheet Functions | |||
VLookup Errors | Excel Worksheet Functions | |||
errors using Vlookup | Excel Worksheet Functions |