Index/Match returning #N/A

[sloany101]

Hello all , i am having some difficulty getting an index/match formula to work across 2 sheets , sheet 1 is a database with personnel info , sheet 2 is a daily POB where when i type in a personnels name in cell c3 i want to return their company they work for in cell f3 and so forth , but when i put the formula in the array portion of index doesnt even seem to be recognized if that makes sense and i end up getting a #N/A below is the current formula i have after reading a few forum posts.

=INDEX('Personnel Info'!$C$3:$AC$100,MATCH(C3,'Personnel Info'!$A$3:$AB$100,1),)

i have vlookup formulas for this that work wonderfully , but they have caused the entire file slow to open trying to find an alternative less volatile function to achieve this , perhaps a VBA function idk .

i can post more info if needed

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what column is the name in on the Personnel Info sheet?

 

[Legacy 143009]

In which columns are Personel names and company names on Sheet1?

 

[sloany101]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what column is the name in on the Personnel Info sheet?

Will do , thanks , the name is in columns A&B as they are merged all the way down

 

[Legacy 143009]

Try

=INDEX('Personnel Info'!$C$3:$C$100,MATCH(C3,'Personnel Info'!$A$3:$A$100,0))

 

[sloany101]

Try

=INDEX('Personnel Info'!$C$3:$C$100,MATCH(C3,'Personnel Info'!$A$3:$A$100,0))

THANKS!!! this worked perfectly , appreciate the help!!

 

[Legacy 143009]

Glad it did work! Thanks for the feedback