Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Can anyone help with this problem. I am using a VLOOKUP to pull information from a worksheet called "Feb Loan 06" This is the exact formula as used in my worksheet: =IF(ISERROR(VLOOKUP($A3,'Feb Loan 06'!$A$2:$D$473,4,FALSE)),0,VLOOKIP($A3,'Feb Loan 06'!$A$2:$D$473,4,FALSE)) I use this formula very regularly but this is the first time the formula does not pull in the correct data. The data it is pulling in should show either the value 0.00 or any other number. There are other numbers larger that 0.00 in the column I am pulling from, but for some reason, the only figure getting pulled through is 0.00, even if the client should have a figure of 3000.00 for example. Any ideas as to what I may be doing wrong. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with time formula so the time will not change. | Excel Discussion (Misc queries) | |||
Time sheets | Excel Worksheet Functions | |||
Formula for a time card | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) |