Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem
I am having a problem with a vlookup fromula returning an #N/A value when
using a cell with another vlookup formula as the lookup_ value. I created this same spreadsheet a year ago and it worked fine. I even opened the old one and I can't see any differences at all. I'd appreciate any help anyone can give. -- tpocccfo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem
We'd be happy to help, but you need to meet us halfway.
What's the formula? What data is providing the #N/A result? Regards, Fred "tpocccfo" wrote in message ... I am having a problem with a vlookup fromula returning an #N/A value when using a cell with another vlookup formula as the lookup_ value. I created this same spreadsheet a year ago and it worked fine. I even opened the old one and I can't see any differences at all. I'd appreciate any help anyone can give. -- tpocccfo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup problem
Well, if I understand correctly, what you describe should work and did on my
small test. So the #N/A says you think the lookup looks the same but it is not. You say it worked before so perhaps something has corrupted the lookup value column entries, like some new imported data or someone changed something and thought they got it back to original data... Try a =A1=C1 type evaluation on the cells that return the n/a. If False that is the villian. HTH Regards, Howard "tpocccfo" wrote in message ... I am having a problem with a vlookup fromula returning an #N/A value when using a cell with another vlookup formula as the lookup_ value. I created this same spreadsheet a year ago and it worked fine. I even opened the old one and I can't see any differences at all. I'd appreciate any help anyone can give. -- tpocccfo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Vlookup Problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Worksheet Functions | |||
Vlookup problem | New Users to Excel | |||
vlookup problem | Excel Discussion (Misc queries) |