Instructions to: Use Excel's intense VLookup highlight to make cross-table/cross-queries. This is a far reaching instructional exercise, demonstrating best practices on all parts of a VLookup. These guidelines work with all renditions of Excel.
Summary:
=Vlookup(what you are searching for, where, which section, correct match=False)
or, on the other hand
=IfError(Vlookup(what, where, section, false),"Not Found")
Rundown of steps:
1. In a different sheet, make table of qualities to query
2. Range-name the query table (short header push)
3. Manufacture VLookup, choosing base-1 segment name
Contents:
VLookup Introduction:
In Excel, a VLookup enables your sheet to query another incentive from another sheet, cross-referencing index data into the present sheet.
For instance, a Master Account number table could demonstrate a portrayal, spending numbers and the individual responsible for that record. At that point, in any number of different sheets, you would lookup be able to the record number and restore those unified esteems into the present exercise manual:
As it were, your sheet could reference an Account number (showed, in Cell B5), and different esteems from the query table, for example, the depiction and spending plan sums, can be returned in a cross-query.
On the off chance that information in the query table changes, for instance, expect the dollar'd spending sum changes, the new sheet gets the new esteem consequently. With this, one gathering of individuals can keep up the record rundown, and all other connected sheets will see the most current esteems.
VLookup Setup:
Assemble an Account Number Master list.
In a (generally) isolate sheet, influence a rundown of qualities to query, with the Account to number as the principal segment. This can be account codes, worker numbers, part-numbers, individuals names, and so forth.
1. Open another, clear spreadsheet.
2. Load or sort account data, where:
The principal section must contain a novel esteem (the Key) for each record.
This is the Account Number
No copy passages are permitted in the principal section.
Any number of sections can take after the primary (Description, spending plan, and so forth.)
Segment headings are prescribed, yet not required.
The rundown *must* be arranged one after another in order/Numerically by the principal section. (In fact, it 'ought to be' arranged on the off chance that you are utilizing "correct coordinating"; it "must" be arranged if not correct coordinating. Arranging is constantly suggested.)
Name the Range:
Albeit discretionary, I suggest naming the information run. Take after these means:
3. Once the query esteems are written, feature the information (all lines, all segments, *not including* the Header push)
a. 'Other-mouse-click' the featured cells, pick "Name a Range"; name the range a significant name, for example, "MyAccounts". No spaces.
a2. (On the other hand: Click top Menu Formulas, Define Name and sort the range, utilizing dollar-signs to bolt the lines and sections. For instance: $A$3:$D$13)
a3. (Another other strategy): Highlight the information, less the segment headers, at that point click in the region straightforwardly above segment A. Sort the range-name there.
The Range-name makes future work easier, see below for more information.
b. Spare the whole sheet to circle, giving it a significant name, for example, "Accounts.xlsx" or "FY17Accounts", and so on.
Once spared, leave the sheet open while building the Vlookup equations.Later on, this sheet can be opened or shut and it will in any case work appropriately - yet in the event that effectively opened, queries are speedier.
Using VLookups in your Sheet
4. In another sheet (File, New, Blank exercise manual), where you need the outcomes to show up, move to a discretionary cell (B5).
5. Truly, sort a record number to search up: For instance, "2356"
6. In another cell, say C5, start the query recipe by writing "=VLookup(" (open enclosure).
Note the popup offer assistance:
a. For the main parameter, after the bracket, click cell B5 (2356). This is the esteem you are endeavoring to turn upward.
* Type a Comma (,) to move to the following parameter.
b. While still amidst the equation's second parameter, take the mouse and snap anyplace in the Account look into sheet. Snap one an opportunity to enact the sheet, a moment time to choose a cell; any cell.
In the event that the sheet is secured or generally not obvious, tap the best Excel menu View, Switch Windows.)
(Since you are utilizing a range-name, you don't have to feature every one of the information, simply click anyplace in the sheet, arbitrarily. This sets the sheet's name. )
In my case, the Account Lookup sheet's base tab was renamed to "MasterAccounts"; on the off chance that you didn't rename the sheet, it will appear as "Sheet1", either is adequate.
Once chose, the second parameter in the Vlookup recipe will seem as though one of these, where the "$B$7" (the arbitrary cell clicked) is insignificant:
=Vlookup(B5,[Accounts.xlsx]MasterAccounts!$B$7 or
=Vlookup(B5, [Accounts.xlsx]Sheet1!$B$7
c. Here is the trap:
While as yet fabricating the second parameter, delete over the recently chose address, erasing the "$B$7" (or what ever cell clicked) - delete up until, yet excluding the shout (likewise called a "blast").
d. Replace the $B$7 (or what ever) with the Ranged-name "MyAccounts":
After backspacing and typing the RangeName "MyAccounts":
=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!MyAccounts
or
=Vlookup(B5, [Accounts.xlsx]Sheet1!MyAccounts
e. Sort a comma (,), after "MyAccounts," to proceed with the recipe.
The following parameter is section information you need returned into the sheet. For the current VLookup cell, this will be the depiction (segment 2). Sort a "2", trailed by another comma:
f. At last, sort a comma-",False", which tells the equation it must locate an Exact-coordinate in the query table; this is the most widely recognized alternative.
g. Close the enclosure) and press Enter. The finished recipe:
=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!MyAccounts,2,False)
=Vlookup(B5, [Accounts.xlsx]Sheet1! MyAccounts,2,False)
Results: The Description for account code 2356 ("Networking") is returned.
Lookup another Column in the same Table
In cell D5, one cell to the right, build another VLookup formula, returning the budget amount:
=VLookup (B5,Accounts.xlsx!MyAccounts,3,False)
where:
Improved VLookup Formula:
There is a plausibility the Vlookup may not locate a given record code; more often than not in light of a mis-keyed esteem or the record does not exist. Test this now by doing the accompanying:
a. In the first cell B5 ("2356"), change the record code to a non-existent record ("2000"). Results: The Vlookup recipes return "#N/A" (Value not found).
Enhance the Formula utilizing IFError:
b. Cosmetically, this can be enhanced with this equation in Cell C5 (all on one line):
IfError(VLookup(B5,Accounts.xlsx! MyAccounts,2,False),"Not Found")
c. In D5, use this formula (note the double-quotes ""):
IfError(VLookup(B5,Accounts.xlsx! MyAccounts,3,False),"")
(Click illustration for larger view, Back to return)
where:
=ifError says if "any piece of the included recipe creates any sort of mistake, (for example, a #N/A"), put an alternate an incentive in the cell. Something else, utilize the first esteem.
Try not to utilize an equivalent sign before the VLookup proviso
In the event that a blunder was discovered, the recipe restores the strict content "Not Found".
Cell D5's recipe, the second VLookup was changed to restore an invalid (exhaust) string (cite) if there was a blunder.
Contingent upon your necessities, the equations could likewise restore a zero (0) rather than the content "Not Found".
Possible Errors:
Range-Name Issues:
On the off chance that you pick not to utilize a range name in the VLookup, you should utilize a cell-run.
=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!$A3:D13 ...
where $A3:D13 are every one of the qualities wrote in the query table.
These sorts of reaches are naturally delicate. On the off chance that new esteems are embedded into the query table while your unique sheet is shut, the queries won't see the change and the wrong range will be chosen, regularly bringing about "#NA" values.
With express locations (A3:D13), the range could possibly extend when new lines are embedded into the table, contingent upon which connected sheets were opened at the time. Contrast this with a range-named table, where embedded records consequently grow the range-name. At the end of the day, unequivocal locations (A3:D13) are hazardous.
In any case, with either the RangeName or unequivocal address cases, recently embedded records at the best most or base most records won't grow the range-names accurately and VLookups will have sporadic disappointments when they are close to these territories. While embeddings new esteems in the query on the first or last line, check the range-name to ensure it is as yet precise.
Confirming an existing Range-Name:
While embeddings records on the best most or base most columns, affirm the range with one of these techniques:
Strategy 1:
Tap the down-trinket ideal above segment A, pick the Range-name "MyAccounts".
Exceed expectations will feature the cells.
Affirm the feature envelops all lines and segments.
See underneath on the off chance that you have to change.
Method 2:
Utilize this strategy to check and, if necessary, to change the chose extend in the Range-name:
In Excel 2007's lace menu, pick "Equations", Name Manager or press Control-F3.
Affirm the range-name cell address (e.g. $A$3:$D$13). The dollar-signs are vital for reasons not depicted here. To change the range-values, tap the red-bolt and re-feature the table. This case demonstrates a sheet with other range-names:
(Click for a larger view, Back to return)
As an aside, you can see every connected sheet (from your primary sheet, not from the Accounts Sheet) by choosing the best menu Data, Edit Links. "Accounts.xlsx" will appear as a connected sheet.
Other Range Names
In the query table sheet, where the MyAccounts go lives, you can have different segments dedicated to other query esteems. For instance, there may be a Department Lookup table, CategoryCodes, Employee query, and so on. All can live in a similar sheet and all will function admirably on the off chance that you utilize Range Names.
Performance Concerns
Vlookups are to some degree costly in CPU handling. On the off chance that your sheet has a huge number of queries, the execution of the sheet could be moderate. Consider the accompanying to enhance the speed:
Open the query sheet *before* opening your fundamental sheet.
On truly vast sheets, set manual re-computation: Menu: Formulas, Calculation Options, Manual. Comprehend the suggestions previously doing this.
The query sheet can be shut and the recipes will even now work; you will be incited for setting up the connection when you open your principle sheet.
Dirty Data:
With numeric queries, once in a while, the query key esteems may look like numbers, however are truly literary. This can happen if the table is populated from a centralized computer download or other ASCII import.
The manifestations are this: Both the query table and the query esteem may indicate "2356" - yet one is numeric and the other is character. At the point when go through the VLookup, you will get a surprising "Not Found" or NA.
To test the literary information, influence a fake equation in another area of the query to sheet. Add +1 to your presumed numeric esteem. On the off chance that it is content, the appropriate response will be "1"; if numeric it will be '2357'. Do likewise for the test an incentive in the vlookup sheet.
In the event that the "numeric" qualities in the query sheet are truly character, adjust the issue by changing over the query section to numeric information. Do this with these means in the query segments:
a. Embed another fake section.
b. Utilize this equation: "=Value()"
c. Fill the equation down the section.
d. Duplicate the equations; utilize Paste-Special, Values-just, finished the highest point of the first "numbers".
e. Erase the spurious segment.
You may likewise locate the first information is dirtied with non-printable characters - for the most part a tab. Consider utilizing comparable strides with a =Clean() equation to spiff the information.
Non-Exact Searches
The last parameter in the VLookup (,"false"), reveals to Excel that a correct match must be found. This is the typical setting for the equation. In any case, you can indicate a non-correct match.
For instance, if the dollar figures were amongst $1,000 and $2,000 dollars, utilize such-and-such General-Ledger number. In any case, if the number were amongst $2,000 and $10,000, utilize an alternate number.
Consider this table, which indicates buy arrange endorsement record data:
Within your own sheet, a lookup of various items purchased, might look like this, where different ledger-numbers and approving people are displayed, depending on the dollar-amount spent:
The formula in cell D4 ($33.56 purchase) would look like this:
=VLOOKUP(B4,Accounts.xlsx!LedgerAccounts,2,TRUE)
where:
With this type of lookup, you do not need the IfError logic used in previous examples -- there is no need unless you expect negative numbers to arrive.
In the lookups, Bob (Ledger account ABC) gets to approve all dollar purchases less than $1,000. If the purchase were $1,000.01, Mary gets the right to approve (not Bodine).
All purchases $30,000 or larger belong to Margret. The rule is this: If no exact match is found, find the next larger value that is less-than the looked-up value.
This concludes the VLookup tutorial. Your comments are welcome.
Related Keyliner Articles:
Excel UDF (User Defined Functions)Using Excel for Raffle-Ticket Drawing: Prizeorama
Excel VLookup - a complete tutorial
Excel Coloring Alternate Rows
Excel Parsing City-State-Zip
Excel Importing Text with Leading Zeroes
VB - Return First Word, Last Word, Supertrim
Using VBA to Send Email
Using Excel to select Raffle Tickets - Prize-orama
Summary:
=Vlookup(what you are searching for, where, which section, correct match=False)
or, on the other hand
=IfError(Vlookup(what, where, section, false),"Not Found")
Rundown of steps:
1. In a different sheet, make table of qualities to query
2. Range-name the query table (short header push)
3. Manufacture VLookup, choosing base-1 segment name
Contents:
- VLookup - Name the Range
- Parameters
- Choosing the Range - the "trap"
- Enhanced VLookup utilizing IfError
- Settling Range Names
- Execution Concerns
- Filthy (Numeric) Data
- Non-correct inquiries (inside a scope of qualities)
VLookup Introduction:
In Excel, a VLookup enables your sheet to query another incentive from another sheet, cross-referencing index data into the present sheet.
For instance, a Master Account number table could demonstrate a portrayal, spending numbers and the individual responsible for that record. At that point, in any number of different sheets, you would lookup be able to the record number and restore those unified esteems into the present exercise manual:
 |
| Click for a larger view |
As it were, your sheet could reference an Account number (showed, in Cell B5), and different esteems from the query table, for example, the depiction and spending plan sums, can be returned in a cross-query.
On the off chance that information in the query table changes, for instance, expect the dollar'd spending sum changes, the new sheet gets the new esteem consequently. With this, one gathering of individuals can keep up the record rundown, and all other connected sheets will see the most current esteems.
VLookup Setup:
Assemble an Account Number Master list.
In a (generally) isolate sheet, influence a rundown of qualities to query, with the Account to number as the principal segment. This can be account codes, worker numbers, part-numbers, individuals names, and so forth.
1. Open another, clear spreadsheet.
2. Load or sort account data, where:
The principal section must contain a novel esteem (the Key) for each record.
This is the Account Number
No copy passages are permitted in the principal section.
Any number of sections can take after the primary (Description, spending plan, and so forth.)
Segment headings are prescribed, yet not required.
The rundown *must* be arranged one after another in order/Numerically by the principal section. (In fact, it 'ought to be' arranged on the off chance that you are utilizing "correct coordinating"; it "must" be arranged if not correct coordinating. Arranging is constantly suggested.)
Name the Range:
Albeit discretionary, I suggest naming the information run. Take after these means:
3. Once the query esteems are written, feature the information (all lines, all segments, *not including* the Header push)
a. 'Other-mouse-click' the featured cells, pick "Name a Range"; name the range a significant name, for example, "MyAccounts". No spaces.
a2. (On the other hand: Click top Menu Formulas, Define Name and sort the range, utilizing dollar-signs to bolt the lines and sections. For instance: $A$3:$D$13)
a3. (Another other strategy): Highlight the information, less the segment headers, at that point click in the region straightforwardly above segment A. Sort the range-name there.
The Range-name makes future work easier, see below for more information.
b. Spare the whole sheet to circle, giving it a significant name, for example, "Accounts.xlsx" or "FY17Accounts", and so on.
Once spared, leave the sheet open while building the Vlookup equations.Later on, this sheet can be opened or shut and it will in any case work appropriately - yet in the event that effectively opened, queries are speedier.
Using VLookups in your Sheet
4. In another sheet (File, New, Blank exercise manual), where you need the outcomes to show up, move to a discretionary cell (B5).
5. Truly, sort a record number to search up: For instance, "2356"
|
| Click for a larger view |
Note the popup offer assistance:
a. For the main parameter, after the bracket, click cell B5 (2356). This is the esteem you are endeavoring to turn upward.
* Type a Comma (,) to move to the following parameter.
b. While still amidst the equation's second parameter, take the mouse and snap anyplace in the Account look into sheet. Snap one an opportunity to enact the sheet, a moment time to choose a cell; any cell.
In the event that the sheet is secured or generally not obvious, tap the best Excel menu View, Switch Windows.)
(Since you are utilizing a range-name, you don't have to feature every one of the information, simply click anyplace in the sheet, arbitrarily. This sets the sheet's name. )
In my case, the Account Lookup sheet's base tab was renamed to "MasterAccounts"; on the off chance that you didn't rename the sheet, it will appear as "Sheet1", either is adequate.
Once chose, the second parameter in the Vlookup recipe will seem as though one of these, where the "$B$7" (the arbitrary cell clicked) is insignificant:
=Vlookup(B5,[Accounts.xlsx]MasterAccounts!$B$7 or
=Vlookup(B5, [Accounts.xlsx]Sheet1!$B$7
c. Here is the trap:
While as yet fabricating the second parameter, delete over the recently chose address, erasing the "$B$7" (or what ever cell clicked) - delete up until, yet excluding the shout (likewise called a "blast").
d. Replace the $B$7 (or what ever) with the Ranged-name "MyAccounts":
After backspacing and typing the RangeName "MyAccounts":=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!MyAccounts
or
=Vlookup(B5, [Accounts.xlsx]Sheet1!MyAccounts
e. Sort a comma (,), after "MyAccounts," to proceed with the recipe.
The following parameter is section information you need returned into the sheet. For the current VLookup cell, this will be the depiction (segment 2). Sort a "2", trailed by another comma:
f. At last, sort a comma-",False", which tells the equation it must locate an Exact-coordinate in the query table; this is the most widely recognized alternative.
g. Close the enclosure) and press Enter. The finished recipe:
=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!MyAccounts,2,False)
=Vlookup(B5, [Accounts.xlsx]Sheet1! MyAccounts,2,False)
Results: The Description for account code 2356 ("Networking") is returned.
Lookup another Column in the same Table
In cell D5, one cell to the right, build another VLookup formula, returning the budget amount:
=VLookup (B5,Accounts.xlsx!MyAccounts,3,False)
where:
- Accounts.xlsx is the name of the sheet
- "MyAccounts" is the name of the named-range
- "3" returns the budget from the third column
- "False" means find an exact match
Improved VLookup Formula:
There is a plausibility the Vlookup may not locate a given record code; more often than not in light of a mis-keyed esteem or the record does not exist. Test this now by doing the accompanying:
a. In the first cell B5 ("2356"), change the record code to a non-existent record ("2000"). Results: The Vlookup recipes return "#N/A" (Value not found).
Enhance the Formula utilizing IFError:
b. Cosmetically, this can be enhanced with this equation in Cell C5 (all on one line):
IfError(VLookup(B5,Accounts.xlsx! MyAccounts,2,False),"Not Found")
c. In D5, use this formula (note the double-quotes ""):
IfError(VLookup(B5,Accounts.xlsx! MyAccounts,3,False),"")
(Click illustration for larger view, Back to return)where:
=ifError says if "any piece of the included recipe creates any sort of mistake, (for example, a #N/A"), put an alternate an incentive in the cell. Something else, utilize the first esteem.
Try not to utilize an equivalent sign before the VLookup proviso
In the event that a blunder was discovered, the recipe restores the strict content "Not Found".
Cell D5's recipe, the second VLookup was changed to restore an invalid (exhaust) string (cite) if there was a blunder.
Contingent upon your necessities, the equations could likewise restore a zero (0) rather than the content "Not Found".
Possible Errors:
- #N/A (#NA) - A correct match was not found in the query table.
- #N/A The query cell address may have moved or changed, affirm the principal parameter is pointing at the esteem you need to query.
- #Name? - An off base or incorrectly spelled RangeName (otherwise known as "MyAccounts") or the range-name does not exist.
On the off chance that you pick not to utilize a range name in the VLookup, you should utilize a cell-run.
=Vlookup
(B5,[Accounts.xlsx]MasterAccounts!$A3:D13 ...
where $A3:D13 are every one of the qualities wrote in the query table.
These sorts of reaches are naturally delicate. On the off chance that new esteems are embedded into the query table while your unique sheet is shut, the queries won't see the change and the wrong range will be chosen, regularly bringing about "#NA" values.
With express locations (A3:D13), the range could possibly extend when new lines are embedded into the table, contingent upon which connected sheets were opened at the time. Contrast this with a range-named table, where embedded records consequently grow the range-name. At the end of the day, unequivocal locations (A3:D13) are hazardous.
In any case, with either the RangeName or unequivocal address cases, recently embedded records at the best most or base most records won't grow the range-names accurately and VLookups will have sporadic disappointments when they are close to these territories. While embeddings new esteems in the query on the first or last line, check the range-name to ensure it is as yet precise.
Confirming an existing Range-Name:
While embeddings records on the best most or base most columns, affirm the range with one of these techniques:
Strategy 1:
Tap the down-trinket ideal above segment A, pick the Range-name "MyAccounts".
Exceed expectations will feature the cells.
Affirm the feature envelops all lines and segments.
See underneath on the off chance that you have to change.
Method 2:
Utilize this strategy to check and, if necessary, to change the chose extend in the Range-name:
In Excel 2007's lace menu, pick "Equations", Name Manager or press Control-F3.
Affirm the range-name cell address (e.g. $A$3:$D$13). The dollar-signs are vital for reasons not depicted here. To change the range-values, tap the red-bolt and re-feature the table. This case demonstrates a sheet with other range-names:
(Click for a larger view, Back to return)
As an aside, you can see every connected sheet (from your primary sheet, not from the Accounts Sheet) by choosing the best menu Data, Edit Links. "Accounts.xlsx" will appear as a connected sheet.
Other Range Names
In the query table sheet, where the MyAccounts go lives, you can have different segments dedicated to other query esteems. For instance, there may be a Department Lookup table, CategoryCodes, Employee query, and so on. All can live in a similar sheet and all will function admirably on the off chance that you utilize Range Names.
Performance Concerns
Vlookups are to some degree costly in CPU handling. On the off chance that your sheet has a huge number of queries, the execution of the sheet could be moderate. Consider the accompanying to enhance the speed:
Open the query sheet *before* opening your fundamental sheet.
On truly vast sheets, set manual re-computation: Menu: Formulas, Calculation Options, Manual. Comprehend the suggestions previously doing this.
The query sheet can be shut and the recipes will even now work; you will be incited for setting up the connection when you open your principle sheet.
Dirty Data:
With numeric queries, once in a while, the query key esteems may look like numbers, however are truly literary. This can happen if the table is populated from a centralized computer download or other ASCII import.
The manifestations are this: Both the query table and the query esteem may indicate "2356" - yet one is numeric and the other is character. At the point when go through the VLookup, you will get a surprising "Not Found" or NA.
To test the literary information, influence a fake equation in another area of the query to sheet. Add +1 to your presumed numeric esteem. On the off chance that it is content, the appropriate response will be "1"; if numeric it will be '2357'. Do likewise for the test an incentive in the vlookup sheet.
In the event that the "numeric" qualities in the query sheet are truly character, adjust the issue by changing over the query section to numeric information. Do this with these means in the query segments:
a. Embed another fake section.
b. Utilize this equation: "=Value()"
c. Fill the equation down the section.
d. Duplicate the equations; utilize Paste-Special, Values-just, finished the highest point of the first "numbers".
e. Erase the spurious segment.
You may likewise locate the first information is dirtied with non-printable characters - for the most part a tab. Consider utilizing comparable strides with a =Clean() equation to spiff the information.
Non-Exact Searches
The last parameter in the VLookup (,"false"), reveals to Excel that a correct match must be found. This is the typical setting for the equation. In any case, you can indicate a non-correct match.
For instance, if the dollar figures were amongst $1,000 and $2,000 dollars, utilize such-and-such General-Ledger number. In any case, if the number were amongst $2,000 and $10,000, utilize an alternate number.
Consider this table, which indicates buy arrange endorsement record data:
Within your own sheet, a lookup of various items purchased, might look like this, where different ledger-numbers and approving people are displayed, depending on the dollar-amount spent:
The formula in cell D4 ($33.56 purchase) would look like this:
=VLOOKUP(B4,Accounts.xlsx!LedgerAccounts,2,TRUE)
where:
- "LedgerAccounts" is a new RangeName in the lookup sheet.
- "2" returns the second column (Ledger-account number)
- "true" says allow inexact matches
With this type of lookup, you do not need the IfError logic used in previous examples -- there is no need unless you expect negative numbers to arrive.
In the lookups, Bob (Ledger account ABC) gets to approve all dollar purchases less than $1,000. If the purchase were $1,000.01, Mary gets the right to approve (not Bodine).
All purchases $30,000 or larger belong to Margret. The rule is this: If no exact match is found, find the next larger value that is less-than the looked-up value.
This concludes the VLookup tutorial. Your comments are welcome.
Related Keyliner Articles:
Excel UDF (User Defined Functions)Using Excel for Raffle-Ticket Drawing: Prizeorama
Excel VLookup - a complete tutorial
Excel Coloring Alternate Rows
Excel Parsing City-State-Zip
Excel Importing Text with Leading Zeroes
VB - Return First Word, Last Word, Supertrim
Using VBA to Send Email
Using Excel to select Raffle Tickets - Prize-orama
No comments:
Post a Comment