I'm trying to lookup a large data(350,000 rows, 15 columns), based on value in column A, and populate the related information under the headings in column B, C, D..... Basically I've been tasked to retrieve all the information about 2000 names randomly selected from the database. Any help will be much appreciated. Attached is a sample.
Put this formula in B19:
=IFERROR(INDEX(B$3:B$7,MATCH($A19,$A$3:$A$7,0)),"")
Copy across into C19:M19, then use the Format Painter icon to copy the formats from B3:M3 into B19:M19. Then you can copy B19:M19 down as far as you need to.
Hope this helps.
Pete
Copy into B19, drag across and down as need. You many need to adjust the formats of the date and amount columns.
=IFERROR(INDEX(B$3:B$7,MATCH($A19,$A$3:$A$7,0)),"")
Once I posted, I saw, Ha Ha, that I'd been bto it!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
By five minutes, Glenn - must type faster !!Originally Posted by Glenn Kennedy
Pete
Normally I refresh before I post, but I've been away for a holiday and forgot.... Y'er just tooo quick
Guys, thanks for the quick response, really looks good!
If I may ask, what if I want the formula to ignore duplicate names?
This link shows how you can do that using an array formula:
http://www.get-digital-help.com/2009...om-one-column/
However, if you really have 350,000 records, then it would probably be better to look for a VBA solution.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks