Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement linked to cell with VLOOKUP problem - getting wrong v
Hi,
I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a VLOOKUP to get the value. This seems to be giving me a false answer in my If statement and it always equals the value in A1. If I just type in the value of A1 (to test it), the If statement works properly.... help. Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement linked to cell with VLOOKUP problem - getting wrong v
Hi Mike
The value returned from the Vlookup, may be displaying a value that is the same as A2, but is actually different e,g, the value might be 2.000345 but with a 2 decimal format may be displaying 2.00 Try =IF(INT(A1)INT(A2),A1,A2) assuming that that level of precision is suitable for your purposes. -- Regards Roger Govier "Mike R." wrote in message ... Hi, I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a VLOOKUP to get the value. This seems to be giving me a false answer in my If statement and it always equals the value in A1. If I just type in the value of A1 (to test it), the If statement works properly.... help. Mike |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement linked to cell with VLOOKUP problem - getting wrong v
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup
vlookup has four arguments and needs to be sorted for it to work properly unless you know you are looking for exact matches,then you use the "false" version Range_lookup A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match: If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned. The values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP may not give the correct value. You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending. For more information, see Default sort orders. If FALSE, VLOOKUP will only find an exact match. In this case, the values in the first column of table_array do not need to be sorted. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned. Remarks -- paul remove nospam for email addy! "Mike R." wrote: Hi, I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a VLOOKUP to get the value. This seems to be giving me a false answer in my If statement and it always equals the value in A1. If I just type in the value of A1 (to test it), the If statement works properly.... help. Mike |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement linked to cell with VLOOKUP problem - getting wrong v
I meant to add before sending, it may also be that the value returned
from the Vlookup is text. In which case =IF(--(A1)A2,A1,A2) the double unary minus -- in front of (A1) will coerce the text value to numeric. -- Regards Roger Govier "Roger Govier" wrote in message ... Hi Mike The value returned from the Vlookup, may be displaying a value that is the same as A2, but is actually different e,g, the value might be 2.000345 but with a 2 decimal format may be displaying 2.00 Try =IF(INT(A1)INT(A2),A1,A2) assuming that that level of precision is suitable for your purposes. -- Regards Roger Govier "Mike R." wrote in message ... Hi, I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a VLOOKUP to get the value. This seems to be giving me a false answer in my If statement and it always equals the value in A1. If I just type in the value of A1 (to test it), the If statement works properly.... help. Mike |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement linked to cell with VLOOKUP problem - getting wro
Roger, this is perfect. Thank you for teaching me something new!
Mike "Roger Govier" wrote: I meant to add before sending, it may also be that the value returned from the Vlookup is text. In which case =IF(--(A1)A2,A1,A2) the double unary minus -- in front of (A1) will coerce the text value to numeric. -- Regards Roger Govier "Roger Govier" wrote in message ... Hi Mike The value returned from the Vlookup, may be displaying a value that is the same as A2, but is actually different e,g, the value might be 2.000345 but with a 2 decimal format may be displaying 2.00 Try =IF(INT(A1)INT(A2),A1,A2) assuming that that level of precision is suitable for your purposes. -- Regards Roger Govier "Mike R." wrote in message ... Hi, I have a simple IF statement that is =IF(A1A2,A1,A2). The cell A1 is a VLOOKUP to get the value. This seems to be giving me a false answer in my If statement and it always equals the value in A1. If I just type in the value of A1 (to test it), the If statement works properly.... help. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making path of linked cell dynamic | Excel Discussion (Misc queries) | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |