Vlookup array Lookup Array HELP WHAT DO I USE......

britt87

New Member
Joined
Jul 19, 2017
Messages
4
I have a work schedule, that I would like to be able to use 1-10 in B5 (LD as it shows on this screen ) and have it update the leave days in G5:AH41 the days of the week as it shows on this screen (based on the master list of leave days on another sheet.)I used =vlookup B5,sheet1B85:AH95,(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30),False) But what I used doesn't recognize the columns.:eeek:

[TABLE="width: 834"]
<colgroup><col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;" span="2"> <col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="45" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 877;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1389;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;"> <col width="24" style="width: 18pt; mso-width-source: userset; mso-width-alt: 877;" span="22"> <tbody>[TR]
[TD="class: xl87, width: 347, bgcolor: yellow, colspan: 6"]Floor Security - Day Shift[/TD]
[TD="class: xl68, width: 45, bgcolor: silver"]M[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]T[/TD]
[TD="class: xl66, width: 36, bgcolor: silver"]W[/TD]
[TD="class: xl66, width: 44, bgcolor: silver"]Th[/TD]
[TD="class: xl66, width: 38, bgcolor: silver"]F[/TD]
[TD="class: xl66, width: 48, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]M[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]T[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]W[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]Th[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]F[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]M[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]T[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]W[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]Th[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]F[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]M[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]T[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]W[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]Th[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]F[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[TD="class: xl66, width: 24, bgcolor: silver"]S[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: silver"]EmpID[/TD]
[TD="class: xl67, bgcolor: silver"]LD [/TD]
[TD="class: xl67, bgcolor: silver"]Rank[/TD]
[TD="class: xl67, bgcolor: silver"]Last Name[/TD]
[TD="class: xl67, bgcolor: silver"]First Name[/TD]
[TD="class: xl67, bgcolor: silver"]Shift[/TD]
[TD="class: xl75, bgcolor: silver"]2/26[/TD]
[TD="class: xl75, bgcolor: silver"]2/27[/TD]
[TD="class: xl75, bgcolor: silver"]2/28[/TD]
[TD="class: xl75, bgcolor: silver"]3/1[/TD]
[TD="class: xl75, bgcolor: silver"]3/2[/TD]
[TD="class: xl75, bgcolor: silver"]3/3[/TD]
[TD="class: xl75, bgcolor: silver"]3/4[/TD]
[TD="class: xl75, bgcolor: silver"]3/5[/TD]
[TD="class: xl75, bgcolor: silver"]3/6[/TD]
[TD="class: xl75, bgcolor: silver"]3/7[/TD]
[TD="class: xl75, bgcolor: silver"]3/8[/TD]
[TD="class: xl75, bgcolor: silver"]3/9[/TD]
[TD="class: xl75, bgcolor: silver"]3/10[/TD]
[TD="class: xl75, bgcolor: silver"]3/11[/TD]
[TD="class: xl75, bgcolor: silver"]3/12[/TD]
[TD="class: xl75, bgcolor: silver"]3/13[/TD]
[TD="class: xl75, bgcolor: silver"]3/14[/TD]
[TD="class: xl75, bgcolor: silver"]3/15[/TD]
[TD="class: xl75, bgcolor: silver"]3/16[/TD]
[TD="class: xl75, bgcolor: silver"]3/17[/TD]
[TD="class: xl75, bgcolor: silver"]3/18[/TD]
[TD="class: xl75, bgcolor: silver"]3/19[/TD]
[TD="class: xl75, bgcolor: silver"]3/20[/TD]
[TD="class: xl75, bgcolor: silver"]3/21[/TD]
[TD="class: xl75, bgcolor: silver"]3/22[/TD]
[TD="class: xl75, bgcolor: silver"]3/23[/TD]
[TD="class: xl75, bgcolor: silver"]3/24[/TD]
[TD="class: xl75, bgcolor: silver"]3/25[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl80, bgcolor: transparent"]L[/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]1[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"]2[/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"]U/B[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"]2[/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]0654-1500[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl72, bgcolor: transparent"]L[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"]
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"][/TD]
[TD="class: xl78, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl84, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,903
Messages
6,175,279
Members
452,630
Latest member
OdubiYouth

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