Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
For simplicity, I have the following vlookup formula listed below, where the
first number would be in cell A3 and the range I'm trying to find the number is in cell A5:B5, and the result is in C5. However, I keep getting an #N/A for my response. I have formatted the entire worksheet and all numbers as a number and not text. This only happens to several rows in my hugh spreadheet. The other formulas work. Any idea why this is happening to these several cells? 63311 63311 40813 #N/A =VLOOKUP(A3,$A$5:$B$5,2,FALSE) Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup occasionally returns formula with no data | Excel Discussion (Misc queries) | |||
Vlookup returns #N/A correctly...but...need formula in another col | Excel Worksheet Functions | |||
@vlookup returns the formula instead of the value - why? | Excel Worksheet Functions | |||
VLookup returns #VALUE! | Excel Worksheet Functions | |||
vlookup returns 0.00 | Links and Linking in Excel |