| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Vlookup not returning correct value
We have a file which is updated monthly containing 'Vllookups' combined with
'IF, ISNA' formulae. This has worked successfully for many months but suddenly will not return correct vlaues for a couple of entries. Nothing has changed within the spreadsheet, except the file name. Can anyone shed any light on this? |
|
#2
|
|||
|
|||
|
I think the data and the formula would help.
-- HTH RP (remove nothere from the email address if mailing direct) "Mandy Brookes" <Mandy wrote in message ... We have a file which is updated monthly containing 'Vllookups' combined with 'IF, ISNA' formulae. This has worked successfully for many months but suddenly will not return correct vlaues for a couple of entries. Nothing has changed within the spreadsheet, except the file name. Can anyone shed any light on this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP not returning results | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| Vlookup and returning #n/a | Excel Worksheet Functions | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| troubleshoot vlookup returning #N/A | Excel Worksheet Functions | |||
Hybrid Mode
