Copy a cell in the same row as a matched cell on a sheet2
Closed
Matt
-
Jul 21, 2016 at 10:15 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 21, 2016 at 11:46 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 21, 2016 at 11:46 AM
Related:
- Copy a cell in the same row as a matched cell on a sheet2
- How to delete a row in a table in word - Guide
- Saints row 2 cheats - 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
- Excel multiple lines in one cell - Guide
- Based on the cell values in cells b77 - Excel Forum
2 responses
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 21, 2016 at 10:59 AM
Jul 21, 2016 at 10:59 AM
Matt, Good morning.
Your formula is correct but if you want put a formula at Sheet1 and get a Value from Sheet2, you need just change the destiny at your formula.
Try to use:
=IFERROR(INDEX(Sheet2!E:E,MATCH(A2,Sheet2!A:A,0)),"X")
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Your formula is correct but if you want put a formula at Sheet1 and get a Value from Sheet2, you need just change the destiny at your formula.
Try to use:
=IFERROR(INDEX(Sheet2!E:E,MATCH(A2,Sheet2!A:A,0)),"X")
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 21, 2016 at 11:46 AM
Jul 21, 2016 at 11:46 AM
Matt, Good afternoon.
"...This formula is giving me values from Sheet2!E:E when there are no matches in Sheet2!A:A..."
This is really very strange.
Your formula is correct and still you have improved the efficiency of the formula by placing the IFERROR Function.
So, if the problem is not in the formula, MUST be in the data.
If you prefer, save your file in a free site, www.speedyshare.com, and put the link here to download.
So it will be easier to help you conclusively.
--
Belo Horizonte, Brasil.
Marcílio Lobão
"...This formula is giving me values from Sheet2!E:E when there are no matches in Sheet2!A:A..."
This is really very strange.
Your formula is correct and still you have improved the efficiency of the formula by placing the IFERROR Function.
So, if the problem is not in the formula, MUST be in the data.
If you prefer, save your file in a free site, www.speedyshare.com, and put the link here to download.
So it will be easier to help you conclusively.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jul 21, 2016 at 11:08 AM
=IFERROR(INDEX(Sheet2!E:E,MATCH(A2,Sheet2!A:A,0)),"X")
This formula is giving me values from Sheet2!E:E when there are no matches in Sheet2!A:A. Any ideas why or any alternatives?