brucecanny
New Member
- Joined
- Oct 27, 2017
- Messages
- 3
First let me acknowledge that each component of my question has been covered however I think this is unique, and probably simpler as I only want to return the value AND format of one cell, but it is from an closed external file. I'm new to VBA and the answers to each component of my question all seem to be very compicated in some way (array's, copying entire sheets or columns...). The INDEX/MATCH works fine however the source fonts have different colors within the same cell and INDEX/MATCH only returns the Value.. I hope this is enough information. Here is my Index Match.
=INDEX('[Race-9-Ball-Balls.xlsx]Race'!$B$2:$Q$17,MATCH(N8,'[Race-9-Ball-Balls.xlsx]Race'!$A$2:$A$17,1),MATCH(N9,'[Race-9-Ball-Balls.xlsx]Race'!$B$1:$Q$1,1))
This is what it returns: [TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl66, width: 54"]❺❼[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 35"]
<tbody>[TR]
[TD="class: xl64, width: 35"]
But I want:
[TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl66, width: 54"]❺❼[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
=INDEX('[Race-9-Ball-Balls.xlsx]Race'!$B$2:$Q$17,MATCH(N8,'[Race-9-Ball-Balls.xlsx]Race'!$A$2:$A$17,1),MATCH(N9,'[Race-9-Ball-Balls.xlsx]Race'!$B$1:$Q$1,1))
This is what it returns: [TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl66, width: 54"]❺❼[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 35"]
<tbody>[TR]
[TD="class: xl64, width: 35"]
But I want:
[TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl66, width: 54"]❺❼[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]