How to Perform a VLOOKUP on Multiple Spreadsheets

Chapter
Question?
Options
Buttons for answers
Name=How to Perform a VLOOKUP on Multiple Spreadsheets££Description=££FrameWidth=1920££FrameHeight=1080££ViewWidth=1024££ViewHeight=576££FramesPerSecond=24££LCID=1033££TXT_STARTALLOWANYSEQUENCE=Please perform the following:££TXT_ENDALLOWANYSEQUENCE=and complete by:££Intro=cl-intro.jpg££Image=1,0,0,1920,1080££ActionInfo=<Step x="686" y="318" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="db75ca2c-7ab5-49be-82ed-0239d1869376" ms="106433109" instructionoff="" thumbnailoff=""><Arg1>$G$2</Arg1><Arg2>CELL</Arg2><Argc><lt><l lcid="1033">G</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">G2</l></lt></Arga><Arg4><lt><l lcid="1033"></l></lt></Arg4><Par1>EXCEL%_CELL</Par1><Par2>$G$2</Par2><Par3><lt><l lcid="1033">G2</l></lt></Par3><Parc><lt><l lcid="1033">G</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">G2</l></lt></Para><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">657</l></lt></X><Y><lt><l lcid="1033">307</l></lt></Y><W><lt><l lcid="1033">85</l></lt></W><H><lt><l lcid="1033">20</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">236850</l></lt></Offset><Offset2><lt><l lcid="1033">236850</l></lt></Offset2><Arg3><lt><l lcid="1033">G2</l></lt></Arg3><InstructionText><lt>Click on the cell G2<l lcid="1033">Click on the cell G2</l></lt></InstructionText><AllowAnyRow></AllowAnyRow><AllowAnyCell></AllowAnyCell></Step>££ActionArea=657,307,742,327££ActionText=Click on the cell G2££ActionFormattedText=Click on the cell G2<br/>££Sound=1££SoundPauseStep=3££ActionWait=1££MouseLeftClick=699,317££Image=2,0,72,1920,972££ActionInfo=<Step cmd="Keyboard" id="52d03ccc-a063-4e9f-85af-f8b0ca88396e" ms="106449093" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>=vlookup(</Arg1><Par1>KEYBOARD</Par1><Par2>=vlookup(</Par2><X><lt><l lcid="1033">729</l></lt></X><Y><lt><l lcid="1033">300</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">290840</l></lt></Offset><Offset2><lt><l lcid="1033">290840</l></lt></Offset2><Arg2></Arg2><InstructionText><lt>Enter the text =vlookup(.<l lcid="1033">Enter the text =vlookup(.</l></lt></InstructionText><Par3 /></Step>££ActionText=Enter the text =vlookup(.££ActionFormattedText=Enter the text =vlookup(.<br/>££Sound=2££SoundPause=3££Image=3,8,68,1912,288££ActionInfo=<Step x="334" y="314" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="f2b4b40b-d6f7-4f7f-ab61-da57ac8ec703" ms="106449140" instructionoff="" thumbnailoff=""><Arg1>$D$2</Arg1><Arg2>CELL</Arg2><Arg4><lt><l lcid="1033">ABC Corp</l></lt></Arg4><Par1>EXCEL%_CELL</Par1><Par2>$D$2</Par2><Par3><lt><l lcid="1033">D2</l></lt></Par3><Par4><lt><l lcid="1033">ABC Corp</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">300</l></lt></X><Y><lt><l lcid="1033">307</l></lt></Y><W><lt><l lcid="1033">85</l></lt></W><H><lt><l lcid="1033">20</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">311005</l></lt></Offset><Offset2><lt><l lcid="1033">311005</l></lt></Offset2><AllowAnyRow></AllowAnyRow><AllowAnyCell></AllowAnyCell><Arg3><lt><l lcid="1033">D2</l></lt></Arg3><InstructionText><lt>T<l lcid="1033">Click on the cell D2 with the value ABC Corp\r\n\r\nThis adds the reference to column D, where we have the Company Name for each Contact, to our formula. We will use this value to match up with a company record.</l></lt></InstructionText></Step>££ActionArea=300,307,385,327££ActionText=Click on the cell D2 with the value ABC Corp\r\n\r\nThis adds the reference to column D, where we have the Company Name for each Contact, to our formula. We will use this value to match up with a company record.££ActionFormattedText=Click on the cell D2 with the value ABC Corp<br/><br/>This adds the reference to column D, where we have the Company Name for each Contact, to our formula. We will use this value to match up with a company record.<br/>££Sound=3££SoundPauseStep=17££ActionWait=1££MouseLeftClick=342,317££Image=4,4,180,1916,856££ActionInfo=<Step id="16c8f83f-1142-4372-821a-d81517b0e9ec" ms="106455343" cmd="Keyboard" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>,</Arg1><Par1>KEYBOARD</Par1><Par2>,</Par2><X><lt><l lcid="1033">725</l></lt></X><Y><lt><l lcid="1033">320</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">315967</l></lt></Offset><Offset2><lt><l lcid="1033">315967</l></lt></Offset2><Arg2></Arg2><Par3></Par3><InstructionText><lt>P<l lcid="1033">Press "," (comma)</l></lt></InstructionText></Step>££ActionText=Press "," (comma)££ActionFormattedText=Press "," (comma)<br/>££Sound=4££SoundPause=2££Image=5,0,0,1920,1080££ActionInfo=<Step x="228" y="1011" exe="EXCEL.EXE" wh="333360" cmd="WinUIA2" mouse="Left" id="d8a901bf-bc95-4982-9aa3-296696bf59fc" ms="106618562" cbinfo="C:\Users\ksayer\AppData\Local\Temp\b9311d2af-0749-41d5-ac66-e0f53f73d31c.clrx|ksayer|2020-05-15T14:30:45.4086799-04:00|2597814|1033" instructionoff="" thumbnailoff=""><Arg1>/Desktop 1/rA/*msxls/rA/r9/rA/vlookup/rA/rA/r3C/Companies</Arg1><Arg2>Pagetab/page tab</Arg2><Arg4>The Sheet Tab represents a single sheet in the book<lt><l lcid="1033">The Sheet Tab represents a single sheet in the book</l></lt></Arg4><Arg5>/9/A/9/A/9/A/9/A/A/3C/25,265,994,177,990,269,1018</Arg5><Arg6>EXCEL.EXE</Arg6><Par1>WINUIA%_Pagetab/page tab</Par1><Par2>/Desktop 1/rA/*msxls/rA/r9/rA/vlookup/rA/rA/r3C/Companies</Par2><Par3><lt><l lcid="1033">Companies</l></lt></Par3><Par4><lt><l lcid="1033">The Sheet Tab represents a single sheet in the book</l></lt></Par4><Parv><lt><l lcid="1033" /></lt></Parv><Pars><lt><l lcid="1033" /></lt></Pars><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">177</l></lt></X><Y><lt><l lcid="1033">990</l></lt></Y><W><lt><l lcid="1033">92</l></lt></W><H><lt><l lcid="1033">28</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="0" y="1040" w="1920" h="40" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="1040" w="1920" h="40" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">2597814</l></lt></Offset><Offset2><lt><l lcid="1033">2597814</l></lt></Offset2><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Arg3><lt>Companies<l lcid="1033">Companies</l></lt></Arg3><InstructionText></InstructionText></Step>££ActionArea=177,990,269,1018££ActionText=Click on the tab Companies.££ActionFormattedText=Click on the tab <b>Companies</b>.<br/>££Sound=5££SoundPauseStep=3££ActionWait=1££MouseLeftClick=223,1004££Image=6,0,0,1920,1080££ActionInfo=<Step x="85" y="275" exe="EXCEL.EXE" wh="333360" cmd="Excel" drag="true" mouse="Left" id="d4ad4b09-e1ce-4573-a1c6-10dd4815dddf" ms="107414187" cbinfo="C:\Users\ksayer\AppData\Local\Temp\b29ca5064-d9f2-4249-b2a8-eface4681842.clrx|ksayer|2020-05-15T14:43:54.0363047-04:00|2856232|1033" instructionoff="" thumbnailoff=""><Arg1>$A</Arg1><Arg2>COLUMN</Arg2><Arg4><lt><l lcid="1033" /></lt></Arg4><Par1>EXCEL%_COLUMN</Par1><Par2>$A</Par2><Par3><lt><l lcid="1033">A</l></lt></Par3><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">26</l></lt></X><Y><lt><l lcid="1033">267</l></lt></Y><W><lt><l lcid="1033">106</l></lt></W><H><lt><l lcid="1033">19</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="0" y="1040" w="1920" h="40" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="1040" w="1920" h="40" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">2856232</l></lt></Offset><Offset2><lt><l lcid="1033">2856232</l></lt></Offset2><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Arg3><lt><l lcid="1033">A</l></lt></Arg3><InstructionText></InstructionText><AllowAnyCell></AllowAnyCell></Step>££ActionArea=26,267,132,286££ActionText=Click and hold the left mouse button on the column header A££ActionFormattedText=Click and hold the left mouse button on the column header <b>A</b><br/>££Sound=6££SoundPauseStep=5££ActionWait=1££MouseLeftClick=79,276££Image=7,0,8,1920,1072££ActionInfo=<Step x="515" y="276" exe="EXCEL.EXE" wh="333360" cmd="Excel" drop="true" mouse="Left" id="fa8bcf8a-0d92-42b6-8d0c-09b6c8521994" ms="107414265" cbinfo="C:\Users\ksayer\AppData\Local\Temp\b29ca5064-d9f2-4249-b2a8-eface4681842.clrx|ksayer|2020-05-15T14:43:54.0363047-04:00|2856232|1033|1033" instructionoff="" thumbnailoff=""><Arg1>$E</Arg1><Arg2>COLUMN</Arg2><Arg4><lt><l lcid="1033" /></lt></Arg4><Par1>EXCEL%_COLUMN</Par1><Par2>$E</Par2><Par3><lt><l lcid="1033">E</l></lt></Par3><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">439</l></lt></X><Y><lt><l lcid="1033">267</l></lt></Y><W><lt><l lcid="1033">130</l></lt></W><H><lt><l lcid="1033">19</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">3086298</l></lt></Offset><Offset2><lt><l lcid="1033">3086298</l></lt></Offset2><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><AllowAnyCell></AllowAnyCell><Arg3><lt><l lcid="1033">E</l></lt></Arg3><InstructionText><lt>B<l lcid="1033">Release the left mouse button on the column header E\r\n\r\nBy selecting these columns, we have effectively selected all the data in this table. Note that it is very important that the value you are looking up (in this case the Company Name) be to the left of the item you want to return (in this case, the Account Manager).</l></lt></InstructionText></Step>££ActionArea=439,267,569,286££ActionText=Release the left mouse button on the column header E\r\n\r\nBy selecting these columns, we have effectively selected all the data in this table. Note that it is very important that the value you are looking up (in this case the Company Name) be to the left of the item you want to return (in this case, the Account Manager).££ActionFormattedText=Release the left mouse button on the column header E<br/><br/>By selecting these columns, we have effectively selected all the data in this table. Note that it is very important that the value you are looking up (in this case the Company Name) be to the left of the item you want to return (in this case, the Account Manager).<br/>££Sound=7££SoundPauseStep=23££ActionWait=1££MouseLeftClick=504,276££Image=8,0,0,1920,1080££ActionInfo=<Step id="89138f7f-84ac-42ed-a794-cdd23f5ae78c" ms="106472640" cmd="Keyboard" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>,3,false)<enter></Arg1><Par1>KEYBOARD</Par1><Par2>,3,false)<enter></Par2><X><lt><l lcid="1033">790</l></lt></X><Y><lt><l lcid="1033">320</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">828416</l></lt></Offset><Offset2><lt><l lcid="1033">828416</l></lt></Offset2><Arg2></Arg2><Par3></Par3><InstructionText><lt>Enter the text ,3,false).<l lcid="1033">Enter the text ,3,false). Press Enter.\r\n\r\n3 refers to the column number of the data you want to be returned. In this case, we want Account Manager, which is in the 3rd column.\r\n\r\nFalse refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."</l></lt></InstructionText></Step>££ActionText=Enter the text ,3,false). Press Enter.\r\n\r\n3 refers to the column number of the data you want to be returned. In this case, we want Account Manager, which is in the 3rd column.\r\n\r\nFalse refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."££ActionFormattedText=Enter the text ,3,false). Press Enter.<br/><br/>3 refers to the column number of the data you want to be returned. In this case, we want Account Manager, which is in the 3rd column.<br/><br/>False refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."<br/>££Sound=8££SoundPause=25££Image=9,0,8,1920,1036££ActionInfo=<Step x="728" y="316" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="d006d2db-1558-44a9-975a-f5d2a3a3b036" ms="106476500"><Arg1>$G$2/r</Arg1><Arg2>CELL</Arg2><Arg3><lt><l lcid="1033">G2</l></lt></Arg3><Argc><lt><l lcid="1033">G</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">G2</l></lt></Arga><Arg4><lt><l lcid="1033">Todd White</l></lt></Arg4><Par1>EXCEL%_CELL_RIGHTPART</Par1><Par2>$G$2/r</Par2><Par3><lt><l lcid="1033">G2</l></lt></Par3><Parc><lt><l lcid="1033">G</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">G2</l></lt></Para><Par4><lt><l lcid="1033">Todd White</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">726</l></lt></X><Y><lt><l lcid="1033">311</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">1374248</l></lt></Offset><Offset2><lt><l lcid="1033">1374248</l></lt></Offset2></Step>££ActionArea=726,311,742,327££ActionText=Click on the right part of the cell G2 with the value Todd White££ActionFormattedText=Click on the right part of the cell <b>G2</b> with the value <b>Todd White</b><br/>££Sound=9££SoundPauseStep=5££ActionWait=1££MouseLeftClick=734,319££Image=10,0,180,1920,172££ActionInfo=<Step x="738" y="324" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="DoubleClick" id="6fe653c0-988d-4254-a838-5b11d9578a4a" ms="106478312" instructionoff="" thumbnailoff=""><Arg1>$G$2/r</Arg1><Arg2>CELL</Arg2><Argc><lt><l lcid="1033">G</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">G2</l></lt></Arga><Arg4><lt><l lcid="1033">Todd White</l></lt></Arg4><Par1>EXCEL%_CELL_RIGHTPART</Par1><Par2>$G$2/r</Par2><Par3><lt><l lcid="1033">G2</l></lt></Par3><Parc><lt><l lcid="1033">G</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">G2</l></lt></Para><Par4><lt><l lcid="1033">Todd White</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">726</l></lt></X><Y><lt><l lcid="1033">311</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">1384653</l></lt></Offset><Offset2><lt><l lcid="1033">1384653</l></lt></Offset2><Arg3><lt><l lcid="1033">G2</l></lt></Arg3><InstructionText><lt>\r\nDouble click on the right part of the cell G2 with the value Todd White\r\n<l lcid="1033">Double click on the right part of the cell G2 with the value Todd White\r\n\r\nThis does a formula paste of our first row into all subsequent rows.\r\n</l></lt></InstructionText><AllowAnyRow></AllowAnyRow><AllowAnyCell></AllowAnyCell></Step>££ActionArea=726,311,742,327££ActionText=Double click on the right part of the cell G2 with the value Todd White\r\n\r\nThis does a formula paste of our first row into all subsequent rows.££ActionFormattedText=Double click on the right part of the cell G2 with the value Todd White<br/><br/>This does a formula paste of our first row into all subsequent rows.<br/><br/>££Sound=10££SoundPauseStep=11££ActionWait=1££MouseDoubleClickClick=734,319££Image=11,0,324,1920,712££ActionInfo=<Step x="469" y="322" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="d212bf78-adad-493a-aaa6-4abc4b71407c" ms="106482937" instructionoff="" thumbnailoff=""><Arg1>$E$2</Arg1><Arg2>CELL</Arg2><Argc><lt><l lcid="1033">E</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">E2</l></lt></Arga><Arg4><lt><l lcid="1033"></l></lt></Arg4><Par1>EXCEL%_CELL</Par1><Par2>$E$2</Par2><Par3><lt><l lcid="1033">E2</l></lt></Par3><Parc><lt><l lcid="1033">E</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">E2</l></lt></Para><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">385</l></lt></X><Y><lt><l lcid="1033">307</l></lt></Y><W><lt><l lcid="1033">130</l></lt></W><H><lt><l lcid="1033">20</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">1405898</l></lt></Offset><Offset2><lt><l lcid="1033">1405898</l></lt></Offset2><Arg3><lt><l lcid="1033">E2</l></lt></Arg3><InstructionText><lt>N<l lcid="1033">Now let's try this on the Industry column. The process is exactly the same.\r\n\r\nClick on the cell E2</l></lt></InstructionText><AllowAnyRow></AllowAnyRow><AllowAnyCell></AllowAnyCell></Step>££ActionArea=385,307,515,327££ActionText=Now let's try this on the Industry column. The process is exactly the same.\r\n\r\nClick on the cell E2££ActionFormattedText=Now let's try this on the Industry column. The process is exactly the same.<br/><br/>Click on the cell E2<br/>££Sound=11££SoundPauseStep=9££ActionWait=1££MouseLeftClick=450,317££Image=12,0,180,1920,856££ActionInfo=<Step id="be116505-5632-4d0c-a50a-0d48a72cd1fb" ms="106490625" cmd="Keyboard" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>=vlookup(</Arg1><Par1>KEYBOARD</Par1><Par2>=vlookup(</Par2><X><lt><l lcid="1033">457</l></lt></X><Y><lt><l lcid="1033">300</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">1437498</l></lt></Offset><Offset2><lt><l lcid="1033">1437498</l></lt></Offset2><Arg2></Arg2><InstructionText><lt>Enter the text =vlookup(.<l lcid="1033">Enter the text =vlookup(.</l></lt></InstructionText><Par3 /></Step>££ActionText=Enter the text =vlookup(.££ActionFormattedText=Enter the text =vlookup(.<br/>££Sound=12££SoundPause=3££Image=13,4,68,1916,976££ActionInfo=<Step x="323" y="323" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="5c13a89d-de45-487c-8c54-6fcbdae7040d" ms="106490687"><Arg1>$D$2</Arg1><Arg2>CELL</Arg2><Arg3><lt><l lcid="1033">D2</l></lt></Arg3><Arg4><lt><l lcid="1033">ABC Corp</l></lt></Arg4><Par1>EXCEL%_CELL</Par1><Par2>$D$2</Par2><Par3><lt><l lcid="1033">D2</l></lt></Par3><Par4><lt><l lcid="1033">ABC Corp</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">300</l></lt></X><Y><lt><l lcid="1033">307</l></lt></Y><W><lt><l lcid="1033">85</l></lt></W><H><lt><l lcid="1033">20</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">1505356</l></lt></Offset><Offset2><lt><l lcid="1033">1505356</l></lt></Offset2></Step>££ActionArea=300,307,385,327££ActionText=Click on the cell D2 with the value ABC Corp££ActionFormattedText=Click on the cell <b>D2</b> with the value <b>ABC Corp</b><br/>££Sound=13££SoundPauseStep=5££ActionWait=1££MouseLeftClick=342,317££Image=14,4,180,1916,856££ActionInfo=<Step id="3f79d51d-bfe1-42b6-a651-bd4a52b9d221" ms="106494984" cmd="Keyboard" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>,</Arg1><Par1>KEYBOARD</Par1><Par2>,</Par2><X><lt><l lcid="1033">453</l></lt></X><Y><lt><l lcid="1033">320</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">1516461</l></lt></Offset><Offset2><lt><l lcid="1033">1516461</l></lt></Offset2><Arg2></Arg2><Par3></Par3><InstructionText><lt>P<l lcid="1033">Press "," (comma)</l></lt></InstructionText></Step>££ActionText=Press "," (comma)££ActionFormattedText=Press "," (comma)<br/>££Sound=14££SoundPause=2££Image=15,4,180,1916,856££ActionInfo=<Step x="223" y="1007" exe="EXCEL.EXE" wh="333360" cmd="WinUIA2" mouse="Left" id="47f42158-ea89-426a-8527-61eaf5da4eea" ms="106495031"><Arg1>/Desktop 1/rA/*msxls/rA/r9/rA/vlookup/rA/rA/r3C/Companies</Arg1><Arg2>Pagetab/page tab</Arg2><Arg3>Companies</Arg3><Arg4>The Sheet Tab represents a single sheet in the book</Arg4><Arg5>/9/A/9/A/9/A/9/A/A/3C/25,265,994,177,990,269,1018</Arg5><Arg6>EXCEL.EXE</Arg6><Par1>WINUIA%_Pagetab/page tab</Par1><Par2>/Desktop 1/rA/*msxls/rA/r9/rA/vlookup/rA/rA/r3C/Companies</Par2><Par3><lt><l lcid="1033">Companies</l></lt></Par3><Par4><lt><l lcid="1033">The Sheet Tab represents a single sheet in the book</l></lt></Par4><Parv><lt><l lcid="1033"></l></lt></Parv><Pars><lt><l lcid="1033"></l></lt></Pars><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">177</l></lt></X><Y><lt><l lcid="1033">990</l></lt></Y><W><lt><l lcid="1033">92</l></lt></W><H><lt><l lcid="1033">28</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">1521111</l></lt></Offset><Offset2><lt><l lcid="1033">1521111</l></lt></Offset2></Step>££ActionArea=177,990,269,1018££ActionText=Click on the tab Companies.££ActionFormattedText=Click on the tab <b>Companies</b>.<br/>££Sound=15££SoundPauseStep=3££ActionWait=1££MouseLeftClick=223,1004££Image=16,0,0,1920,1080££ActionInfo=<Step x="88" y="281" exe="EXCEL.EXE" wh="333360" cmd="Excel" drag="true" mouse="Left" id="78f5c7e4-e704-4f76-bf94-23a656505516" ms="106501000" cbinfo="C:\Users\ksayer\Documents\How to Perform a VLOOKUP on Multiple Spreadsheets.clrx|ksayer|2020-05-15T14:51:39.4384675-04:00|3793914|1033" instructionoff="" thumbnailoff=""><Arg1>$A</Arg1><Arg2>COLUMN</Arg2><Arg4><lt><l lcid="1033" /></lt></Arg4><Par1>EXCEL%_COLUMN</Par1><Par2>$A</Par2><Par3><lt><l lcid="1033">A</l></lt></Par3><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">26</l></lt></X><Y><lt><l lcid="1033">267</l></lt></Y><W><lt><l lcid="1033">74</l></lt></W><H><lt><l lcid="1033">19</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">3793914</l></lt></Offset><Offset2><lt><l lcid="1033">3793914</l></lt></Offset2><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Arg3><lt><l lcid="1033">A</l></lt></Arg3><InstructionText></InstructionText><AllowAnyCell></AllowAnyCell></Step>££ActionArea=26,267,100,286££ActionText=Click and hold the left mouse button on the column header A££ActionFormattedText=Click and hold the left mouse button on the column header <b>A</b><br/>££Sound=16££SoundPauseStep=5££ActionWait=1££MouseLeftClick=63,276££Image=17,0,0,1920,1080££ActionInfo=<Step x="515" y="276" exe="EXCEL.EXE" wh="333360" cmd="Excel" drop="true" mouse="Left" id="c2fd434e-d9ea-4385-ae4d-ccb3979ea539" ms="107414265" cbinfo="C:\Users\ksayer\Documents\How to Perform a VLOOKUP on Multiple Spreadsheets.clrx|ksayer|2020-05-15T14:49:23.5250819-04:00|3331513|1033" instructionoff="" thumbnailoff=""><Arg1>$E</Arg1><Arg2>COLUMN</Arg2><Arg4><lt><l lcid="1033" /></lt></Arg4><Par1>EXCEL%_COLUMN</Par1><Par2>$E</Par2><Par3><lt><l lcid="1033">E</l></lt></Par3><Par4><lt><l lcid="1033"></l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">439</l></lt></X><Y><lt><l lcid="1033">267</l></lt></Y><W><lt><l lcid="1033">130</l></lt></W><H><lt><l lcid="1033">19</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">3331513</l></lt></Offset><Offset2><lt><l lcid="1033">3331513</l></lt></Offset2><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><InstructionText></InstructionText><AllowAnyCell></AllowAnyCell><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Arg3><lt><l lcid="1033">E</l></lt></Arg3></Step>££ActionArea=439,267,569,286££ActionText=Release the left mouse button on the column header E££ActionFormattedText=Release the left mouse button on the column header <b>E</b><br/>££Sound=17££SoundPauseStep=4££ActionWait=1££MouseLeftClick=504,276££Image=18,0,0,1920,1080££ActionInfo=<Step id="e75fee2e-1155-4ecc-ab30-5ab437afb506" ms="106511625" cmd="Keyboard" instructionoff="" thumbnailoff="" fixedinput="" caretinput=""><Arg1>,5,false)<enter></Arg1><Par1>KEYBOARD</Par1><Par2>,5,false)<enter></Par2><X><lt><l lcid="1033">605</l></lt></X><Y><lt><l lcid="1033">300</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><Offset><lt><l lcid="1033">2028655</l></lt></Offset><Offset2><lt><l lcid="1033">2028655</l></lt></Offset2><Arg2></Arg2><Par3></Par3><InstructionText><lt>Enter the text ,5,false). Press the Enter key.<l lcid="1033">Enter the text ,5,false). Press the Enter key.\r\n\r\n5 refers to the column number of the data you want to be returned. In this case, we want the industry of the company to come back, which is in the 5th column.\r\n\r\nFalse refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."</l></lt></InstructionText></Step>££ActionText=Enter the text ,5,false). Press the Enter key.\r\n\r\n5 refers to the column number of the data you want to be returned. In this case, we want the industry of the company to come back, which is in the 5th column.\r\n\r\nFalse refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."££ActionFormattedText=Enter the text ,5,false). Press the Enter key.<br/><br/>5 refers to the column number of the data you want to be returned. In this case, we want the industry of the company to come back, which is in the 5th column.<br/><br/>False refers to if you will accept a partial match. In this case, we want the match to be exact, so we will type out "False."<br/>££Sound=18££SoundPause=27££Image=19,0,8,1920,1036££ActionInfo=<Step x="484" y="320" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="Left" id="14c57b66-e6f7-4383-891b-e09d3e597b88" ms="106514828"><Arg1>$E$2</Arg1><Arg2>CELL</Arg2><Arg3><lt><l lcid="1033">E2</l></lt></Arg3><Argc><lt><l lcid="1033">E</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">E2</l></lt></Arga><Arg4><lt><l lcid="1033">Media</l></lt></Arg4><Par1>EXCEL%_CELL</Par1><Par2>$E$2</Par2><Par3><lt><l lcid="1033">E2</l></lt></Par3><Parc><lt><l lcid="1033">E</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">E2</l></lt></Para><Par4><lt><l lcid="1033">Media</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">385</l></lt></X><Y><lt><l lcid="1033">307</l></lt></Y><W><lt><l lcid="1033">130</l></lt></W><H><lt><l lcid="1033">20</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">2587406</l></lt></Offset><Offset2><lt><l lcid="1033">2587406</l></lt></Offset2></Step>££ActionArea=385,307,515,327££ActionText=Click on the cell E2 with the value Media££ActionFormattedText=Click on the cell <b>E2</b> with the value <b>Media</b><br/>££Sound=19££SoundPauseStep=4££ActionWait=1££MouseLeftClick=450,317££Image=20,0,180,1920,172££ActionInfo=<Step x="510" y="324" exe="EXCEL.EXE" wh="333360" cmd="Excel" mouse="DoubleClick" id="98adfa01-3c3e-4c17-ac51-833a897c99ee" ms="106516390" instructionoff="" thumbnailoff=""><Arg1>$E$2/r</Arg1><Arg2>CELL</Arg2><Argc><lt><l lcid="1033">E</l></lt></Argc><Argr><lt><l lcid="1033">2</l></lt></Argr><Arga><lt><l lcid="1033">E2</l></lt></Arga><Arg4><lt><l lcid="1033">Media</l></lt></Arg4><Par1>EXCEL%_CELL_RIGHTPART</Par1><Par2>$E$2/r</Par2><Par3><lt><l lcid="1033">E2</l></lt></Par3><Parc><lt><l lcid="1033">E</l></lt></Parc><Parr><lt><l lcid="1033">2</l></lt></Parr><Para><lt><l lcid="1033">E2</l></lt></Para><Par4><lt><l lcid="1033">Media</l></lt></Par4><ParentRect><lt><l lcid="1033" x="0" y="267" w="1455" h="751" /></lt></ParentRect><X><lt><l lcid="1033">499</l></lt></X><Y><lt><l lcid="1033">311</l></lt></Y><W><lt><l lcid="1033">16</l></lt></W><H><lt><l lcid="1033">16</l></lt></H><ParBookmarkWindow><lt><l lcid="1033" x="-8" y="-8" w="1936" h="1056" /></lt></ParBookmarkWindow><ParBookmarkWindowClient><lt><l lcid="1033" x="0" y="0" w="1920" h="1040" /></lt></ParBookmarkWindowClient><Offset><lt><l lcid="1033">2597813</l></lt></Offset><Offset2><lt><l lcid="1033">2597813</l></lt></Offset2><Arg3><lt><l lcid="1033">E2</l></lt></Arg3><InstructionText><lt>Double click on the right part of the cell E2 with the value Media<l lcid="1033">Double click on the right part of the cell E2 with the value Media\r\n\r\nYou can repeat this process as many times as you like to combine spreadsheets as your business process requires.</l></lt></InstructionText><AllowAnyRow></AllowAnyRow><AllowAnyCell></AllowAnyCell></Step>££ActionArea=499,311,515,327££ActionText=Double click on the right part of the cell E2 with the value Media\r\n\r\nYou can repeat this process as many times as you like to combine spreadsheets as your business process requires.££ActionFormattedText=Double click on the right part of the cell E2 with the value Media<br/><br/>You can repeat this process as many times as you like to combine spreadsheets as your business process requires.<br/>££Sound=20££SoundPauseStep=13££ActionWait=1££MouseDoubleClickClick=507,319££Outro=cl-outro.jpg££