Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup
I am using a vlookup to find a specific value in a 2 column array.
=VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it returns the correct value sometimes and incorrect values at other times. Any suggestions? |
#2
|
|||
|
|||
Quote:
1 (or TRUE) will make Excel look for a nearest match and will require the lookup array to be in ascending order. 0 (or FALSE) will ensure Excel looks for an exact match only. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
Hi,
Am Mon, 5 Nov 2012 19:26:26 +0000 schrieb CH Coffieid: I am using a vlookup to find a specific value in a 2 column array. =VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it returns the correct value sometimes and incorrect values at other times. Any suggestions? if you use false into the formula the columns must be sorted ascending Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |