"#VALUE!" Cell Value

D

DisMusBeDaPlaz

Some of my cells are turning up the value "#VALUE!" in the cells.

I have duplicated the problem that I am having. A test worksheet.
I am using data in one work sheet, but, two table areas.
The second table is reliant of some data from the first table.
The intersecting result in the first table turns currency amounts, which is
what I want.
When data from the first table is left blank the intersecting data in the
second table
turns up "#VALUE!". This of course is an ambiguous result that does not
have a purposed result.
If you feel you are able to assist with this problem you can e-mail me at:
(e-mail address removed)
Please use the subject in this message. Thanks.
 

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

Similar Threads

vlookup, hlookup and return value of intersecting cell 3
Scrabble Value calculation for Welsh words 0
Lookup against concatenated source value 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Return cell referance of the first cell that equals a value? 5
Update cell value based on name and specific date 1
return value from table 2
Macro Question 8

Top