About Us

Sent you an email.

Biff

"Serge" wrote in message
...
I can be reached at:

"Biff" wrote:

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

In the formula you posted:

=IF(ISNA(VLOOKUP(C2,INDIRECT(VLOOKUP(R5:S8),2*C9)) ),TRUE))

You're using the TRUE argument in the Vlookup so I just assumed that in
fact
your table is sorted. The 1 is just a "shorthand" way of using TRUE.

VLOOKUP(A1,B:C,2,TRUE)
VLOOKUP(A1,B:C,2,1)

VLOOKUP(A1,B:C,2,FALSE)
VLOOKUP(A1,B:C,2,0)

Now, about your follow-up....

I'm a little confused.

You have 2 drop downs and you want to be able to select from one but not
the
other and vice versa?

How do you determine which drop down can be used if the selections are
the
same for both?

I may need to see this for myself to get a better understanding. If you
want
me to take a look at your file let me know how to contact you.

Biff

"Serge" wrote in message
...
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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup in pivot tables	abakay	Excel Worksheet Functions	0	March 27th 06 02:04 AM
vlookup tables for pictures?	WBTKbeezy	Excel Worksheet Functions	1	February 15th 06 03:34 PM
Vlookup Tables	Lianne	Excel Worksheet Functions	1	February 15th 06 11:51 AM
VLookUp / 2 Tables	carl	Excel Discussion (Misc queries)	2	January 17th 06 09:56 PM
can vlookup search multiple data tables	Nadia	Excel Discussion (Misc queries)	6	June 6th 05 05:52 AM

Menu

About Us