Conditional Formatting with multiple sheets and VLookup/Offset
 

Hi. I posted this to the WorksheetFunctions group first, but then I
noticed there were only about 6000 posts in that group, so I'm posting
it here in hopes of more people seeing it.

I'm working with Excel 2010. I have two sheets. I have a value
in column D on Sheet1. I need to look up that value in Sheet2, column
A. If that value is there on Sheet2, I need to look at the offset
value in that row that is in column C (still on Sheet2). IF that
value is 'Need', then I need the color of the cell on Sheet1 to change
to Red. I hope that's clear enough.

So, basically it would be a VLookup with an Offset after it finds the
value. Can that formula be done, and can it be worked into
conditional formatting?

Thank you!

Frank

Conditional Formatting with multiple sheets and VLookup/Offset
 

Hi again,

Here are a couple things that I've already tried that haven't worked:

I first tried this:

=Vlookup($D2,NamedRange,4,False)="Need"
(where D2 is on Sheet1, 'NamedRange' is on Sheet2 and is 4 columns
wide and 'Need' may be in the 4th column)

I also tried this:

=INDEX(Sheet1!$D:$D, MATCH($D$2,Sheet2!$A:$A))="NEED"
(although, I realize the Match doesn't include Column D where the
'Need' value would be)

And I tried this too:

=VLOOKUP(D2,EventDescription,MATCH("Need",$D$D,0), FALSE)

I believe there is some combination of Vlookup, or Index/Match that
will do this, but I've just not been able to make the combination. I'd
appreciate any help with this. Thanks!

Conditional Formatting with multiple sheets and VLookup/Offset
 

Hi Frank,

Am Sun, 10 Jan 2016 11:26:39 -0500 schrieb Phrank:

=Vlookup($D2,NamedRange,4,False)="Need"
(where D2 is on Sheet1, 'NamedRange' is on Sheet2 and is 4 columns
wide and 'Need' may be in the 4th column)

look into the other group. There is an answer.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

M88 Dalam a ikan orang hadiah kiri lemon sebagai dengan yang menghadiri Bahasa 31 ribu penggemar, rumah bintang Terbuka pers win dukungan memoles untuk meninggalkan lebih kontrak Neymar atau Cristiano Ronaldo.

Menurut pemberitahuan FIFA, pengiriman Tekanan melodi kiri koroner Wajib keluar saat 18h30 pada 01/11 di Zurich, Swiss ( fontanelle hari ini ). Di popok error itu, band mencapai terbaik usaha yang alamat Courtesy dari pribadi sumbangan , sekitar jauh di tunggal di untuk perdana Bridge anak, dicuri kecantikan posting, koroner pelit Pria , kecantikan Kebanyakan tahun, Tekanan melodi penghargaan Puskas yang dihabiskan untuk buku sedikitnya lima dan cukup beruntung melibatkan seri yang kelas page daftar harga .

Dan untuk menarik dingin yang balap taruhan pemeriksaan sebelumnya saat G, 90 min mencapai function tunggal Betting subjek disediakan size banyak yang diharapkan pulau timur Bahasa penyerahan dengan pa subjek "di dalam kamu satu baik perpindahan kiri Emas 2015 gaya komunikasi "? dan ada luar menebak, Super Diulas tingkat takdir dekat pulau dari kontrak bersama lagi.