V-Lookup, return the next string

[San Antonio Heat]

I have data on a sheet called "returns" where data is stored, could be multiple lines of the same data just different quantities

On another sheet called "Looking for Something", in cell C5, you type in a part# (Example 32193). It will provide a lot of data from multiple pages that are hidden.

In D17 I am trying to find the first listing by searching the return sheet and finding in the A column the first 32193. I am using this formua
=IFERROR(VLOOKUP($C$5,returns!$A:$I,4,1),"")
In E17 I use this formula =IFERROR(VLOOKUP($C$5,returns!A:I,8,0),"") and in F17 I use this formula =IFERROR(VLOOKUP($C$5,returns!A:I,9,0),"")

In D18 I am trying to find the next listing using the part# in cell C5. This formula used to work but it no longer works for some reason and not sure why.
=IFERROR(VLOOKUP($C$5&"1",returns!$A:$I,4,0),"")

D19 =IFERROR(VLOOKUP($C$5&"2",returns!$A:$I,4,0),"")

I attached a couple of pictures. Any idea why it won't find the next match?

 

[jasonb75]

This formula used to work but it no longer works for some reason

No matter how sure you are that it once did, that formula would never work for what you want it to do. What it would in fact do is return the first match for "321931" or "321932" (if there was a match).

To find subsequent matches you will need to use the FILTER function (if you have a new enough version of excel) or an index array formula for older versions.

Please update your account details (by clicking on the link in my signature block) to show which version of excel you are currently using. Remember to scroll to the bottom and click 'Save changes' after selecting a version.