I have a sheet that is completed by a customer which I need to search based on a keyword, locate the cell that has that keyword, shift one cell down, copy that cells info and paste to another sheet. I would normally just use = to copy the cells information over but I don't know where the info entered by the customer will start.
Attach a sample workbook and I can be more specific. This probably will involve FIND, MATCH and INDEX, possibly as an array formula.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hopefully the file attached. What I am looking to do is search Column A on Sheet 1 for the word "Door Number" and then shift down one cell and take that data and put it in A1 on Sheet 2.
Like this...
=INDEX(Sheet1!A:A,MATCH("Door Number",Sheet1!A:A,0)+1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks