Hi,
I consider myself to be reasonbly good with Excel, but just lately I have been having some problems with vlookups!
I currently have a simple spreadsheet with 2 worksheets.
The first worksheet has detailed information regarding my products.
I am trying to get the second worksheet to look up and return a certain column in the first.
When I enter the formula if I use a FALSE statement in the lookup it returns all #N/A's, if I dont use false it returns information (but not the correct information)
Can somebody please help me out here because it is very frustrating not understanding why it is doing this all of a sudden!
Thanks in advance.
Regards
Sara
I consider myself to be reasonbly good with Excel, but just lately I have been having some problems with vlookups!
I currently have a simple spreadsheet with 2 worksheets.
The first worksheet has detailed information regarding my products.
I am trying to get the second worksheet to look up and return a certain column in the first.
When I enter the formula if I use a FALSE statement in the lookup it returns all #N/A's, if I dont use false it returns information (but not the correct information)
Can somebody please help me out here because it is very frustrating not understanding why it is doing this all of a sudden!
Thanks in advance.
Regards
Sara