VLOOKUP Skip Row If Not A Match?

[Pmarsden94]

Hi,

I know this is Excel based but most of the formulas work for Google Sheets.

I am trying to get VLOOKUP to SKIP a row if the data is not a MATCH....

See image below of the Data Source

Then I have 10 separate tabs where we input the Agent Allocation which a VLOOKUP on the separate tabs will pull this data through. See below the image where the tab is trying to pull the data too.

Instead of returning the exact row location where the matching data is I want it to skip the rows that don't match and just keep adding the next matching row. Like the picture below....

I would like to resolve this without Script as this requires every user to have a Gmail login in order for the Script to work for each person.

Thanks!!!

 

[Pmarsden94]

Wherever you want the data to start.

Wherever you want the data to start.

Worked a treat, can over complicate these things sometimes but keeping it simple was the best. Thanks for the help!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[varunaron]

Not all formulas in Excel will work in sheets.