Conditional Formatting with two Spreadsheets

[Gos-C]

Hi,

I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup the values in E5:E104 of Spreadsheet2, in range F5:K104 on Spreadsheet1, and if column K of Spreadsheet1 is greater than or equal to 1, then highlight the row in Spreadsheet2.

VLOOKUP won't work because the numbers are not in order.

Any suggestion?

Thanks,
Gos-C

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gos-C]

I named F5:K104 of sheet1 RangeMayWk1, then entered =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula, but it didn't work. Any suggestion?

Gos-C

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gos-C]

Still seeking help . . .

Gos-C

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Gos-C]

May I send a sample of my work book to someone who would like to help me with the code?

Thanks

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson

[Gary Brown]

Only addressing the vlookup issue.
The 4th argument of vlookup (range_lookup) should be FALSE, then vlookup
will work fine even w/o the data being in order.
HTH,
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> Hi,
>
> I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
> column E of Spreadsheet2 on Spreadsheet1, and if column K of
> Spreadsheet1 is greater than or equal to 1, then highlight the row in
> Spreadsheet2.
>
> VLOOKUP won't work because the numbers are not in order.
>
> Any suggestion?
>
> Thanks,
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Gary Brown]

When you say 'it didn't work', what do you mean?
--
Gary Brown
[email protected]
Please rate this posting if it is helpful to you.


"Gos-C" wrote:

>
> I named F5:K104 of sheet1 RangeMayWk1, then entered
> =VLOOKUP(E5,RangeMayWk1,6,False) as the conditional formatting formula,
> but it didn't work. Any suggestion?
>
> Gos-C
>
>
> --
> Gos-C
>
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278
>
>

[Dave Peterson]

You didn't answer Gary's question.

But if you want to check to see if that value is > 1, then shouldn't that be
part of your CF formula?

=VLOOKUP(E5,RangeMayWk1,6,FALSE)>1



Gos-C wrote:
>
> Still seeking help . . .
>
> Gos-C
>
> --
> Gos-C
>
> ------------------------------------------------------------------------
> Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
> View this thread: http://www.excelforum.com/showthread...hreadid=376278

--

Dave Peterson