Godd morning Biff,
Yes I have a validation list drop down menu with four selections for C2 &
C3. The selections are the same for both cells, But each cell look up
different tables so that's why I must select one cell or the other giving me
the results in C13. If a selection has been made in one of the cell, I need
to get a message somehow that a selection has been made in the previous cell
if by mistake I made a selection in the second cell before deleting the entry
in the previous cell.

In yesterday's VLOOKUP formula reply can you explain the function of "1" in
the formula, (what does it do?)


"Biff" wrote:

Hi!

That sounds like you'd have to configure your drop downs somehow.

I'm getting ready to call it a day so maybe someone will chime in. If not,
I'll check back here tomorrow.

Biff

"Serge" wrote in message
...
Hello Biff,
Fantastic, You did it again. It works great.
With the same formula basicaly, I want to use it in C3 for another table
with the appropriate change in the formula. But now comes another
chalange.
C2 & C3 have a validation list for four different selections. If I select
data from C2 I should not be able to make a selection from C3 or visa
versa.
Can something be done for this senario?
Thank you so much.
Serge
"Biff" wrote:

Hi!

Try this:

=IF(ISNA(VLOOKUP(C2,R5:S8,2,1)),"",VLOOKUP(C
2,R5:S8,2,1)*C9)

Biff

"Serge" wrote in message
...
=IF(ISNA(VLOOKUP(C2,INDIRECT(VLOOKUP(R5:S8),2*C9)) ),TRUE))
The formula above requires modification.
R5:S8 is also a table named "Max_Weight_Table" which has four
selections
of
materials in R5:R8 and weights in S5:S8.
When C2 matches a material in column R it should multiply the
corresponding
weight by C9.
Can someone help please.
Thank you in advance.
I need to be away for two hours. I will check when I come back.
Serge