VLOOKUP - Multiple Criteria

G

gregula82

New Member
Joined
Aug 18, 2006
Messages
8
Hi Everyone,

I was wondering whether anyone knew of a way of performing a VLOOKUP function which has multiple criteria. e.g. the lookup value would have 3 separate criteria and then you put the table array in and the column index.

Any ideas???

Thanks.

Greg.
 
Sort by date Sort by votes
Rockfish said:
Thank you for your insight. Have been working with this all day and it works great in the example I provided. Turns out I provided an oversimplified example and that breaks the solution all to pieces. The "huge honkin" budget sheet is actuall of the form
[TABLE="width: 476"]
<tbody>[TR]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl79, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl79, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q2
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q2
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Q2
[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: yellow"] Actual
[/TD]
[TD="class: xl79, bgcolor: yellow"] Budget
[/TD]
[TD="class: xl79, bgcolor: yellow"] Commit
[/TD]
[TD="class: xl79, bgcolor: yellow"] Actual
[/TD]
[TD="class: xl79, bgcolor: yellow"] Budget
[/TD]
[TD="class: xl79, bgcolor: yellow"] Commit
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Actual
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Budget
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Commit
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Actual
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Budget
[/TD]
[TD="class: xl80, bgcolor: #B7DEE8"] Commit
[/TD]
[/TR]
</tbody>[/TABLE]
Taking three rows to do what I represented at one row and throwing another bunch of non-unique values into the mix. Row one is used for filters.
Is it still possible to pick the desired values from the spreadsheet?
Thanks and sorry for the mistake.
Rockfish
Click to expand...

Is the difference in the headers? Could you create a sample illustrative of your data along with the results you want to see?
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
I believe it is also possible to use

=INDEX(D1:D5,MATCH("x"&"y"&"z",A1:A5&B1:B5&C1:C5,0))

instead of suggested

=INDEX(D1:D5,MATCH(1,(A1:A5="x")*(B1:B5="y")*(C1:C5="z"),0))

Ctrl+Shift+Enter is needed though as it still is an array formula.


 
Upvote 0
Rockfish said:
Thank you for your insight. Have been working with this all day and it works great in the example I provided. Turns out I provided an oversimplified example and that breaks the solution all to pieces. The "huge honkin" budget sheet is actuall of the form
[TABLE="width: 476"]
<TBODY>[TR]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 49, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 53, bgcolor: transparent"][/TD]
[TD="class: xl78, width: 56, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: yellow"]Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"]Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"]Jun
[/TD]
[TD="class: xl79, bgcolor: yellow"]Jul
[/TD]
[TD="class: xl79, bgcolor: yellow"]Jul
[/TD]
[TD="class: xl79, bgcolor: yellow"]Jul
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q1
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q1
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q1
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q2
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q2
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Q2
[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: yellow"]Actual
[/TD]
[TD="class: xl79, bgcolor: yellow"]Budget
[/TD]
[TD="class: xl79, bgcolor: yellow"]Commit
[/TD]
[TD="class: xl79, bgcolor: yellow"]Actual
[/TD]
[TD="class: xl79, bgcolor: yellow"]Budget
[/TD]
[TD="class: xl79, bgcolor: yellow"]Commit
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Actual
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Budget
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Commit
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Actual
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Budget
[/TD]
[TD="class: xl80, bgcolor: #b7dee8"]Commit
[/TD]
[/TR]
</TBODY>[/TABLE]
Taking three rows to do what I represented at one row and throwing another bunch of non-unique values into the mix. Row one is used for filters.
Is it still possible to pick the desired values from the spreadsheet?
Thanks and sorry for the mistake.
Rockfish
Click to expand...
Could you possibly make up a SMALL sample file that demonstrates your data layout along with the desired results?

You can't directly attach a file in these forums but you can upload a file to some other site and then post a link to that file. You can use a free file hosting site if needed.
 
Upvote 0
[TABLE="width: 581"]
<COLGROUP><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 2048" width=56><COL style="WIDTH: 119pt; mso-width-source: userset; mso-width-alt: 5814" width=159><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1572" width=43><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1682" width=46><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><TBODY>[TR]
[TD="class: xl80, width: 56, bgcolor: transparent"] [/TD]
[TD="class: xl81, width: 159, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"]
[/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"] [/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: yellow"] Jun [/TD]
[TD="class: xl83, bgcolor: yellow"] Jun [/TD]
[TD="class: xl83, bgcolor: yellow"] Jun [/TD]
[TD="class: xl83, bgcolor: yellow"] Jul [/TD]
[TD="class: xl83, bgcolor: yellow"] Jul [/TD]
[TD="class: xl83, bgcolor: yellow"] Jul [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q1 [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q1 [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q1 [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q2 [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q2 [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Q2 [/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: yellow"] Actual [/TD]
[TD="class: xl83, bgcolor: yellow"] Budget [/TD]
[TD="class: xl83, bgcolor: yellow"] Commit [/TD]
[TD="class: xl83, bgcolor: yellow"] Actual [/TD]
[TD="class: xl83, bgcolor: yellow"] Budget [/TD]
[TD="class: xl83, bgcolor: yellow"] Commit [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Actual [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Budget [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Commit [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Actual [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Budget [/TD]
[TD="class: xl84, bgcolor: #b7dee8"] Commit [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Belgium [/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]12 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]72 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]76 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]73 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]50 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]67 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]31 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]83 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]83 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]16 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]100 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]76 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]63 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]64 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]60 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]53 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Training [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]40 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]60 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]7 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]8 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]26 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]10 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]23 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]69 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]34 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]17 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Canada [/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]48 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]59 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]35 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]12 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]30 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]98 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]95 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]53 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]38 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]68 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]92 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Training [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]88 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]34 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]97 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]81 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]59 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]55 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]98 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]30 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]13 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]35 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Denmark [/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]48 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]85 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]42 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]2 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]91 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]88 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]52 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]70 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]10 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]55 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]94 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]11 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Training [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]19 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]29 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]27 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]14 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]73 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]57 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]46 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]50 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]94 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]23 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]16 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]47 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Ecuador [/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]36 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]11 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]19 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]78 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]65 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]100 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]81 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]56 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]91 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]31 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]95 [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Training [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]27 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]41 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]41 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]85 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]75 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]21 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]7 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61 [/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]26 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]70 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]80 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]75 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]57 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]13 [/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86 [/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
Rockfish said:
[TABLE="width: 581"]
<tbody>[TR]
[TD="class: xl80, width: 56, bgcolor: transparent"][/TD]
[TD="class: xl81, width: 159, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 43, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 46, bgcolor: transparent"][/TD]
[TD="class: xl82, width: 50, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl83, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl83, bgcolor: yellow"] Jun
[/TD]
[TD="class: xl83, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl83, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl83, bgcolor: yellow"] Jul
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q1
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q2
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q2
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Q2
[/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: yellow"] Actual
[/TD]
[TD="class: xl83, bgcolor: yellow"] Budget
[/TD]
[TD="class: xl83, bgcolor: yellow"] Commit
[/TD]
[TD="class: xl83, bgcolor: yellow"] Actual
[/TD]
[TD="class: xl83, bgcolor: yellow"] Budget
[/TD]
[TD="class: xl83, bgcolor: yellow"] Commit
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Actual
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Budget
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Commit
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Actual
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Budget
[/TD]
[TD="class: xl84, bgcolor: #B7DEE8"] Commit
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Belgium
[/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]12
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]72
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]76
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]73
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]50
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]67
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]31
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]83
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]83
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]100
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]76
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]63
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]64
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]53
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Training
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]40
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]26
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]23
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]69
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]34
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]17
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Canada
[/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]48
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]59
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]35
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]12
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]30
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]98
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]95
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]53
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]15
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]38
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]68
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]92
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Training
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]88
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]34
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]97
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]81
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]28
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]59
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]55
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]98
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]30
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]13
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]74
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]35
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]90
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Denmark
[/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]48
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]85
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]42
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]91
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]88
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]52
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]70
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]55
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]94
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Training
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]19
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]29
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]27
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]73
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]57
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]46
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]96
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]50
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]89
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]49
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]39
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]94
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]23
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]47
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"] Ecuador
[/TD]
[TD="class: xl85, bgcolor: transparent"] Air Travel
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]36
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]51
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]37
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]19
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]78
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]18
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Other T&E
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]24
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]65
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]100
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]44
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]81
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]56
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]91
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]31
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]95
[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Training
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]43
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]27
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]41
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]41
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]87
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]85
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]75
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]21
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61
[/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"][/TD]
[TD="class: xl85, bgcolor: transparent"] Recruiting/Relocation
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]62
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]26
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]58
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]70
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]33
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]80
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]75
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]57
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]61
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]13
[/TD]
[TD="class: xl86, bgcolor: transparent, align: right"]86
[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...

Thanks... The row and column headers in your exhibit appear to have trailing spaces. If this is really the case in your sheet, try to run the TrimAll macro to remove them.

Sheet1, A1:N18...

[TABLE="width: 740"]
<tbody>[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 157, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Jun
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Jun
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Jun
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Jul
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Jul
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Jul
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Q1
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Q1
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Q1
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Q2
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Q2
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Q2
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 157, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Commit
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Commit
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Commit
[/TD]
[TD="class: xl66, width: 54, bgcolor: transparent"]Actual
[/TD]
[TD="class: xl66, width: 58, bgcolor: transparent"]Budget
[/TD]
[TD="class: xl66, width: 62, bgcolor: transparent"]Commit
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"]Belgium
[/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Air Travel
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]15
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]12
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]72
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]76
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]18
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]73
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]50
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]67
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]58
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]31
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]83
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Other T&E
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]83
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]16
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]100
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]76
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]54
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]63
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]64
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]60
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]43
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]86
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]53
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Training
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]74
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]40
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]60
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]61
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]7
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]58
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]8
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]89
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]54
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]44
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]26
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]49
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]18
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]10
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]23
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]69
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]15
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]96
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]34
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]17
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]28
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]39
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"]Canada
[/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Air Travel
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]48
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]59
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]24
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]35
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]86
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]39
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]12
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]30
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]28
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]44
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Other T&E
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]98
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]95
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]53
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]24
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]15
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]38
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]68
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]49
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]54
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]92
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]74
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Training
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]88
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]34
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]97
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]81
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]28
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]87
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]59
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]74
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]55
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]98
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]30
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]13
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]90
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]90
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]43
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]37
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]74
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]35
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]90
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"]Denmark
[/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Air Travel
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]49
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]48
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]6
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]85
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]42
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]2
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]96
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]91
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]88
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]52
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]70
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Other T&E
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]25
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]10
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]89
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]1
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]61
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]25
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]55
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]94
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]51
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Training
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]19
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]20
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]29
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]27
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]45
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]14
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]37
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]73
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]57
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]46
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]96
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]37
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]18
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]50
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]89
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]49
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]39
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]94
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]4
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]23
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]47
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"]Ecuador
[/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Air Travel
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]51
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]36
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]51
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]61
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]37
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]62
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]11
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]19
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]62
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]78
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]18
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Other T&E
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]54
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]24
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]65
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]100
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]44
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]87
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]22
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]81
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]56
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]91
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]31
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]95
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Training
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]43
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]27
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]54
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]41
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]41
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]87
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]85
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]75
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]21
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]61
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 125, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 157, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]62
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]26
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]58
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]70
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]33
[/TD]
[TD="class: xl67, width: 54, bgcolor: transparent"]80
[/TD]
[TD="class: xl67, width: 58, bgcolor: transparent"]75
[/TD]
[TD="class: xl67, width: 62, bgcolor: transparent"]57
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

Create a 4-row range on a convenient place with the following entries:
[TABLE="width: 129"]
<tbody>[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Air Travel
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Other T&E
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Training
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[/TR]
</tbody>[/TABLE]

Select this range and name it Categories.

Sheet2, A:C, shows example processing...

[TABLE="width: 266"]
<tbody>[TR]
[TD="class: xl66, width: 98, bgcolor: white"][/TD]
[TD="class: xl66, width: 121, bgcolor: white"][/TD]
[TD="class: xl65, width: 135, bgcolor: white"]Q1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 98, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 121, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 135, bgcolor: transparent"]Actual
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 98, bgcolor: transparent"]Belgium
[/TD]
[TD="class: xl66, width: 121, bgcolor: transparent"]Training
[/TD]
[TD="class: xl65, width: 135, bgcolor: transparent"]8
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

C3, control+shift+enter, not just enter:
Rich (BB code): 
=INDEX(Sheet1!$C$3:$N$18,
  MATCH($A3,Sheet1!$A$3:$A$18,0)+(MATCH($B3,Categories,0)-1),
  MATCH(1,IF(Sheet1!$C$1:$N$1=$C$1,IF(Sheet1!$C$2:$N$2=C$2,1)),0))
As you see, it's a conceptually similar solution as before. This one has to do with two sets of column headers.
 
Upvote 0
As with so many, I am interrupt-driven. Sorry for the terse Thank You. Will post additional comments and feedback when I get back on the primary stack.....
.....rockfish
 
Upvote 0
Aladin Akyurek said:
Thanks... The row and column headers in your exhibit appear to have trailing spaces. If this is really the case in your sheet, try to run the TrimAll macro to remove them.
So I am working on this, but there are leading single quotes, then spaces, then the text to search on.
Example: ' Salary
One does not see the quote in the cell unless the cell is selected. Then it appears in the edit box and in the cell being edited. Does this affect what is being attempted here?

Sheet1, A1:N18...Snip....brevity. I renamed the sheets in question Sheet1 and Sheet2 to make things a little more uniform and streamlined. I also deleted row 1 which is/was blank in the example given and the real spreadsheet.

Create a 4-row range on a convenient place with the following entries:
[TABLE="width: 129"]
<TBODY>[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Air Travel
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Other T&E
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Training
[/TD]
[/TR]
[TR]
[TD="class: xl65, width: 172, bgcolor: transparent"]Recruiting/Relocation
[/TD]
[/TR]
</TBODY>[/TABLE]

Select this range and name it Categories. Rockfish>> Done and have tried them with the leading single quote & spaces and without. No Joy.

Sheet2, A:C, shows example processing...

[TABLE="width: 266"]
<TBODY>[TR]
[TD="class: xl66, width: 98, bgcolor: white"][/TD]
[TD="class: xl66, width: 121, bgcolor: white"][/TD]
[TD="class: xl65, width: 135, bgcolor: white"]Q1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 98, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 121, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 135, bgcolor: transparent"]Actual
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 98, bgcolor: transparent"]Belgium
[/TD]
[TD="class: xl66, width: 121, bgcolor: transparent"]Training
[/TD]
[TD="class: xl65, width: 135, bgcolor: transparent"]8
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

C3, control+shift+enter, not just enter:
Rich (BB code): 
=INDEX(Sheet1!$C$3:$N$18,
  MATCH($A3,Sheet1!$A$3:$A$18,0)+(MATCH($B3,Categories,0)-1),
  MATCH(1,IF(Sheet1!$C$1:$N$1=$C$1,IF(Sheet1!$C$2:$N$2=C$2,1)),0))
As you see, it's a conceptually similar solution as before. This one has to do with two sets of column headers.
Click to expand...

Looking at your code, line 1 appears to define the data source on Sheet1? Presuming yes so have modified that line to encapsulate the whole of the data on Sheet1. In reality the range is C3:AX1982. Is there a limit? Wondering why Columns A & B are omitted?

Line 2 seems to parsing colA and colB to find A3 and B3. Don't get the function of the Categories table though.
Recall that there are loads of rows for each country and the country is only in Column A once. Column B runs its full range of accounts, then Column A states another country and Column B runs its full range of accounts. Column A is mostly empty. I could do a fill-down for all blanks in Column A if that would help.

Line 3 seems to be parsing Row 1 & 2 in Sheet1 to match the row1 and row2 values above where the code is entered. Are all the $ present or required?

Cell C3 on Sheet2 contains:

=INDEX(Sheet1!$C$3:$AX$1982,
MATCH($A3,Sheet1!$A$3:$A$1982,0)+(MATCH($B3,Categories,0)-1),
MATCH(1,IF(Sheet1!$C$1:$AX$1=$C$1,IF(Sheet1!$C$2:$AX$2=C$2,1)),0))

I make sure to do the CSE each time I change anything. Unfortunately it returns #N/A.

Argh.
Rockfish
 
Upvote 0
Rockfish said:

Looking at your code, line 1 appears to define the data source on Sheet1? Presuming yes so have modified that line to encapsulate the whole of the data on Sheet1. In reality the range is C3:AX1982. Is there a limit? Wondering why Columns A & B are omitted?

Line 2 seems to parsing colA and colB to find A3 and B3. Don't get the function of the Categories table though.
Recall that there are loads of rows for each country and the country is only in Column A once. Column B runs its full range of accounts, then Column A states another country and Column B runs its full range of accounts. Column A is mostly empty. I could do a fill-down for all blanks in Column A if that would help.

Line 3 seems to be parsing Row 1 & 2 in Sheet1 to match the row1 and row2 values above where the code is entered. Are all the $ present or required?

Cell C3 on Sheet2 contains:

=INDEX(Sheet1!$C$3:$AX$1982,
MATCH($A3,Sheet1!$A$3:$A$1982,0)+(MATCH($B3,Categories,0)-1),
MATCH(1,IF(Sheet1!$C$1:$AX$1=$C$1,IF(Sheet1!$C$2:$AX$2=C$2,1)),0))

I make sure to do the CSE each time I change anything. Unfortunately it returns #N/A.

Argh.
Rockfish
Click to expand...

I'm afraid the quoting structure in your post is difficult to use...

Some comments:

1) Entries like ' Salary can be cleaned and it's better to do so. By the way, there is no need for prefixing a text entry with a single quote. Stray spaces thwart exact matching.

2) Creating a range housing categories should not be a problem (see the workbook to which I give a link below). We should avoid leading and trailing spaces.

Here is the workbook I used...

http://tinyurl.com/92wftzg
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Matching multiple criteria that includes comma separated value
Replies
2
Views
102
Rokcmd
R
A
  • Solved
Index Match With Multiple Criteria
Replies
3
Views
240
acool
A
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
561
Peter_SSs
Peter_SSs
J
  • Solved
Filter function with multiple and|or criteria not working
Replies
3
Views
447
Peter_SSs
Peter_SSs
D
  • Solved
Matching TODAY() using VLOOKUP
Replies
7
Views
165
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,923
Messages
6,175,399
Members
452,640
Latest member
steveridge

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top