Mistakenly posted in Functions Repost here

I need a formula for conditional formatting... that will compare the value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value


Thanks!

Your formula returns TRUE for me. What problem are you having?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy" wrote in message
...
Mistakenly posted in Functions Repost here

I need a formula for conditional formatting... that will compare the
value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value


Thanks!

Thanks for your response
I got it working now I found some stray characters




"Sandy Mann" wrote:

Your formula returns TRUE for me. What problem are you having?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy" wrote in message
...
Mistakenly posted in Functions Repost here

I need a formula for conditional formatting... that will compare the
value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value


Thanks!