LOOKUP Function

D

dhunter43

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?
 
J

Jerry W. Lewis

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

Jerry
 
D

dhunter43

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top