If a range of cells = to a name
Closed
Stormdronk
-
Apr 11, 2011 at 10:26 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 12, 2011 at 12:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 12, 2011 at 12:41 AM
Related:
- If a range of cells = to a name
- How to increase wifi range - Guide
- Excel vba range find - Guide
- How to delete cells in word - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Based on the values in cells b77 b88 ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 12, 2011 at 12:41 AM
Apr 12, 2011 at 12:41 AM
I have given sheet1 and sheet2 in html format. I hope it will come on your reply correctly. see formals in column B in sheet 2 confirm whether you get the data correctly.
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:185px;" /><col style="width:145px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Company Contact Info</td><td > 6 R 350 R 2100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Google Map</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Submit Enquire</td><td > 5 R 350 R 175</td></tr></table><br /><br /><b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:231px;" /><col style="width:151px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=VLOOKUP(A1,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B2</td><td >=VLOOKUP(A2,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B3</td><td >=VLOOKUP(A3,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B4</td><td >=VLOOKUP(A4,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B5</td><td >=VLOOKUP(A5,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B6</td><td >=VLOOKUP(A6,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B7</td><td >=VLOOKUP(A7,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B8</td><td >=VLOOKUP(A8,Sheet1!$A$1:$B$11,2,0)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:185px;" /><col style="width:145px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Company Contact Info</td><td > 6 R 350 R 2100</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >Google Map</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Submit Enquire</td><td > 5 R 350 R 175</td></tr></table><br /><br /><b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:231px;" /><col style="width:151px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Image Gallary</td><td > 8 R 350 R2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Welcome Message </td><td >10 R 350 R 3500</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Website Introduction</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Transitional Banner</td><td > 8 R 350 R 2800</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Company Profile</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >History</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Announcements</td><td > 5 R 350 R 1750</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >General Publications</td><td >10 R 350 R 3500</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=VLOOKUP(A1,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B2</td><td >=VLOOKUP(A2,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B3</td><td >=VLOOKUP(A3,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B4</td><td >=VLOOKUP(A4,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B5</td><td >=VLOOKUP(A5,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B6</td><td >=VLOOKUP(A6,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B7</td><td >=VLOOKUP(A7,Sheet1!$A$1:$B$11,2,0)</td></tr><tr><td >B8</td><td >=VLOOKUP(A8,Sheet1!$A$1:$B$11,2,0)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4 </a>
