VLOOKUP Highlight

[seenfresh]

I have a VLOOKUP as follows:

=IF(ISNA(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)),0,(VLOOKUP(A3,'[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'!$D:$H,5,0)))

I would like to highlight the target cell in '[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'! that is being picked up by the VLOOKUP, any color is okay

I would appreciate any help!

Thx

Sean

 

[seenfresh]

Could I just simply c/format based on the logic answer of True when I enter

=D3='[National Revenue Allocation.xls]Monster Online (2)'!$A$3
off into a unused column in ws Monster

The only thing is I don't want to enter any value or formating in column D of the Monster ws because it is an outside source to document from and I can't make any changes to it to other VLOOKUPS because it is the dependant value. Hope this makes sense

How would I write a c/f that would hold IF($0$3)="True"

Once again thx guys you truley know your stuff!

Sean

 

[NBVC]

simply,

=$O$3=TRUE

 

[seenfresh]

Format

I am trying to conditional format the Bold station cell based on the value in column P if it holds TRUE, I just want to highlight the bold station name if so, also only the bold station names are visible on the ws.

If I do conditional formating I can't drag the formula down because it will change each continuing cell contents.

Is there a way to c/f so that I don't have to create one for each bold station in column D ?

MonsterOnline_Impressions_Julye06.xls
	D	E	F	G	H	I	J	K	L	M	N	O	P
3	FOX43				$0.46					FOX43		FOX43	TRUE
4	FOX43	SuperBanner-728X90			$0.14					FOX43		FOX43	TRUE
5	FOX43	MediumRectangle-300X250			$0.32					FOX43		FOX43	TRUE
6	KAIT				$56.89					KAIT		KAIT	TRUE
Monster, July 2006 (2)

 

[NBVC]

I think you lost me.

Which formula can't you drag down? Why?

Maybe your formula in P should be? =And(D3=O3,D3<>O2)

 

[just_jon]

=AND(P3=TRUE,MATCH(D3,D:D,0)=ROW(D3))

Assumes you are wanting to bold up the 1st instance.

I don't understand O3.

 

[seenfresh]

O3 is used to verify if the Station in cA is TRUE had to do a VLOOKUP back to my other wb to see which stations are present and which are not according to my original VLOOKUP. Now when I enter the formula

=AND(P3=TRUE,MATCH(D3,D:D,0)=ROW(D3))

for c/f it works, but I want to be able to c/f all of the bold stations in column D which goes to around D900 or so, I can't copy c/f formula to the next cell D4 it changes the Station name to FOX43. I just want make the c/f active for all cells D3:D900 Would I have to create a macro for something like this?

 

[just_jon]

Boy, am I confused now!

I thought we had

1] 2 workbooks, one of which had a VLOOKUP into the 2nd, and

2] in this 2nd book, you wished to highlight the value/row currently returned in the VLOOKUP

Is this the arrangement?

 

[seenfresh]

Yes this is correct, sorry about the confusion just having trouble keeping up!

 

[just_jon]

And does A3 of bookname/sheetname=?? hold the target value?

 

[seenfresh]

This is '[National Revenue Allocation.xls]Monster Online (2)'! where it has the VLOOKUP into the other!

Yes only the stations in this wb have the stations in the corresponding D column, in [2nd]wb '[MonsterOnline_Impressions_Julye06.xls]Monster, July 2006 (2)'! Some stations in this wb are not present in [1]Wb that's ok.

National Revenue Allocation.xls
	A	B	C	D	E
3	FOX43	Lin	0%	0.46	0.67
4	KAIT	Raycom	50%	56.89	83.67
5	KASA	Raycom	50%	58.19	85.57
6	KATC	Cordillera	50%	848.05	1,247.13
7	KCAU	Citadel	50%	49.45	72.72
Monster Online (2)