I've got a list of data, let's say 10 columns and 1500 rows.
I would like to write code to lookup value A in column 3, or value B in column 4. If there is a match, single row/entire column is copied to location in new work sheet.
I have not started yet, but would like to know what's a good approach. VLookup type code is useless I found.
From an excel formula point of view, INDEX & MATCH looks promising.
The Find Method is versatile.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks, such a useful method.
This is a slight tangent, but what if one of the values is found in cell E18, what method/function would I use to copy and paste the range A18:J18?
I guess I've attached a sample of what I mean.
Example looks up "Pear" in column I and number "15" in column J and returns/copy and pastes row range to new location.
Try pasting the following into cell N3, then dragging down and across. (Untested):Formula:
Please Login or Register to view this content.
If it doesn't work, I suggest uploading the spreadsheet from which the screenshot is taken by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks