Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
In my spreadsheet in cell A3. I have a number 001700.
In my next spreadsheet rates, the number is displayed as 1700. When I use this forumla, excel doesn't recognize this as the same number. I have tried changing the format so the numbers look the same, but still no luck. What am I doing wrong? =IF(ISNA(VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE)),0 ,VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE)) -- Me |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Multiply both nos by 1 into the adjacent cell
=A3*1 and see whether it works Most likly you have 1700 as the number in your cell which is formatted as '000000' hence showing as 0001700 or you might have it as text. In that case you can EDIT|PASTE SPECIAL|VALUE the cell you get after using the formula =A3*1 -- If you find this post helpful pl. choose "Yes"... "Joan" wrote: In my spreadsheet in cell A3. I have a number 001700. In my next spreadsheet rates, the number is displayed as 1700. When I use this forumla, excel doesn't recognize this as the same number. I have tried changing the format so the numbers look the same, but still no luck. What am I doing wrong? =IF(ISNA(VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE)),0 ,VLOOKUP(A3,RATES'!$A$1:$B$172,2,FALSE)) -- Me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
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 | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |