Good evening experts,
I have an Excel 2007 spreadsheet as follows:
A.................B........C........D........E........F......G......H.....I
1 Cat...........10.......40.....14G
2 Rat...........12.......80.....15H
3 Mouse.......14.....160.....16I
4 Dog..........16......320....17K
5 Bird..........18......640....18R
6 Fish..........20....1280....19T
7 Monkey.....22....2560....20S
8 Snake.......24....3500....21P
When I place the following formula in cell E1: Formula: =MATCH("*dog*",A1:A8,0) Results: 4
The animal 'Dog' does not always appear on row 4 so whatever row it does appear on I want to paste the values of all cells to the right of it in the cells on row 1
In this case: I want to place the values of cells B4, C4, and D4 into cells F1, G1, and H1
In cell F1 I tried the formula ="b"&MATCH("*dog*",A1:A8,0) but it does not work
I realize that I might have to do this via some code in the Visual Basic window, calling this code via a command button (which I have tried)
I am open to anything you can do to help, but I am restricted to working within the confines of the Excel Workbook.
Thanks ,
Jim
Bookmarks