IF and LOOKUP Problems

[Newdlj]

I am having 1 major problem currently, and will have another problem
potentially in the near future.

In the last tab "Weekly Time Sheet", I have created a pivot table,
which works to perfection. I have also created in Column A a
description for each of the codes given in the pivot table. This
description is pulled from a range that has been created in N18:O76.
However, the problem is, I can't seem to figure out how to have a blank
cell show up if there is not a code given in column B. There is no
guarantee that I will work on the same projects on a weekly basis. Is
there a way to include a lookup statement and an IF or OR statement
together? Or perhaps there is an easier way to do it all together.

Secondly, the biggest problem. Although the LOOKUP range will work
currently, because I have manually established which codes and
descriptions go into it. However, the project codes are constantly
being updated. How can I make sure that my range is constantly being
updated as well? Any suggestions on that?

If anyone needs me to send them the file, I will. You can also get a
visual from the attached image.

Attachment filename: screen shot.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=428852

 

[olark]

I think I had a similar problem. I solved it by creating an inde
number in my source data. A unique number that I can cross referenc
with vlookup/if statement (conditional sum wizard, helped).

hope that helps you in the right direction

 

[Frank Kabel]

Hi
for your first issue try the following:
=IF(B1="","",your_vlookup_formula)
or if you want to check for errors (that is the code in cell B1 is not
found in your lookup table) try:
=IF(ISNA(your_vlookup_formula),"",your_vlookup_formula)

Your second issue: Do you want to make sure that your lookup range is
large enough?. If yes, two possible solutions:
- make it quite large (including blank rows)
- use for the range something linke:
=VLOOKUP(search_criteria,OFFSET($A$1,0,0,COUNTA($A:$A),2),col_index,fal
se)

HTH
Frank