MATCH, INDEX or LOOKUP

[RankinC]

Hi all,

I'm hoping for some help with a query I have. I'm currently drafting a quick spreadsheet, this will consist of 2 tabs. The first tab will list such information as "permit holders name", "date" as well as a "permit number"; the person can appear on this tab on numerous occassions, however the permit number will be unique.

Tab 2 will consist of all our permit holders, email address then the permit numbers they have been issued by our company. The permit numbers will go from column H to FF, with around 140 rows of permit holder names.

What i'm hoping to do is create a column on tab 1 that cross references the permit holders name (column C) against the corresponding name on tab 2 (column A), returning a value of "yes" or "no" dependent if that permit was issued to that person.

I hope that makes sense. Thanks for your help

Chris

 

[etaf]

why do the numbers go from h to ff on tab 2

so the names are unique and so are the numbers

will they actually get issued with 155 different numbers per employee

 

[oldbrewer]

can the same permit number be issued to more than one person ?

 

[FDibbins]

In addition to the above questions, maybe something like...=if(iserror(match(cell-with-permit-number,range-with-all-permits,0)),"No","Yes")

 

[RankinC]

why do the numbers go from h to ff on tab 2

so the names are unique and so are the numbers

will they actually get issued with 155 different numbers per employee

The numbers (permits) are unique, so for each person i've entered them individually as I didn't think a search function would be able to pick up a range in one cell (i.e. entering 100-500).

And yes, all numbers are unqiue as well as the individual numbers. One employee could be issued with 25 permits, whilst another could be issued with 125.

Cheers

 

[RankinC]

In addition to the above questions, maybe something like...=if(iserror(match(cell-with-permit-number,range-with-all-permits,0)),"No","Yes")

Thanks FDibbins,

That worked if the range was set for the individual person. If its possible, the idea is that the range would cover everything on Tab 2 rather than an indivdual line

Cheers

 

[FDibbins]

Can you show some sample data and expected outcome please?