I have 15 columns, with different headings, in worksheet1. I have a data
input form arranged in rows in worksheet2. I used a lookup function to locate
and move data from worksheet2 to worksheet1. My problem is that the Lookup
function in the adjacent cell adopts the data in the previous cell even
though the function should return #N/A.
The other possibility that I really like is to add the lookup function as an
argument inside an IF function. This way if there were no data the formula
would return a "0". Is this possible and what would the expression look like?

--
dhunter43
The Performance Advantage, LLC

Use VLOOKUP or HLOOKUP instead of LOOKUP. They have an optional final
argument that you can use to require exact matches.

Jerry

"dhunter43" wrote:

I have 15 columns, with different headings, in worksheet1. I have a data
input form arranged in rows in worksheet2. I used a lookup function to locate
and move data from worksheet2 to worksheet1. My problem is that the Lookup
function in the adjacent cell adopts the data in the previous cell even
though the function should return #N/A.
The other possibility that I really like is to add the lookup function as an
argument inside an IF function. This way if there were no data the formula
would return a "0". Is this possible and what would the expression look like?

--
dhunter43
The Performance Advantage, LLC

I tried both. The problem is;i.e. the result in cell 'b17' shows up in cell
'b18' when the lookup function doesn't find a match. This is a problem
because I only want matched values to exist in order to know which cells to
use in a subsequent scheduling calculation.
My work around is a rather long 'IF' statement but it is populating the
cells as I want it to. It just seems to me that one of the LOOKUP functions
should have given me the results I was looking for.
OR perhaps a method for inserting a lookup function inside an 'IF' statement?
--
dhunter43
The Performance Advantage, LLC


"Jerry W. Lewis" wrote:

Use VLOOKUP or HLOOKUP instead of LOOKUP. They have an optional final
argument that you can use to require exact matches.

Jerry

"dhunter43" wrote:

I have 15 columns, with different headings, in worksheet1. I have a data
input form arranged in rows in worksheet2. I used a lookup function to locate
and move data from worksheet2 to worksheet1. My problem is that the Lookup
function in the adjacent cell adopts the data in the previous cell even
though the function should return #N/A.
The other possibility that I really like is to add the lookup function as an
argument inside an IF function. This way if there were no data the formula
would return a "0". Is this possible and what would the expression look like?

--
dhunter43
The Performance Advantage, LLC