michaelpashley
New Member
- Joined
- Mar 23, 2017
- Messages
- 1
Hi, and apologies but I could not find the answer on historic threads.
I am trying to pull data through using vlookup where there are multiple entries within the table. I have been using OFFSET and MATCH to move on cells, using the below formula:
=IFERROR(VLOOKUP($K$14,OFFSET(REPORT!$B3,MATCH($K$14,REPORT!$B3:B20269,0),0,20000,5),5,0),"")
Basically, I want to pull all individual data entries from column F when the data in column B matches K14 on another sheet.
this works well when the range is limited to the data I need being at the top, but on a much larger range where the data is further into it (I am using a 20,000 line range) the formula brings the same data up over and over.
Question is; can anyone advise how to amend the "B3" entry on the formula to pick up on the next cell down from the last result instead of just the next cell on the list?
I am trying to pull data through using vlookup where there are multiple entries within the table. I have been using OFFSET and MATCH to move on cells, using the below formula:
=IFERROR(VLOOKUP($K$14,OFFSET(REPORT!$B3,MATCH($K$14,REPORT!$B3:B20269,0),0,20000,5),5,0),"")
Basically, I want to pull all individual data entries from column F when the data in column B matches K14 on another sheet.
this works well when the range is limited to the data I need being at the top, but on a much larger range where the data is further into it (I am using a 20,000 line range) the formula brings the same data up over and over.
Question is; can anyone advise how to amend the "B3" entry on the formula to pick up on the next cell down from the last result instead of just the next cell on the list?