Index Match Function

[awiley1]

Morning.

Im trying to setup a very simple index match function, but seem to be running into snags. I have two sheets. Sheet #1 has assigned person column A and account number column D.

Sheet 2 is new info. I have account number, but would like to quickly populate column A with assigned person.

The formula I was using was =INDEX(Sheet1!A:A,MATCH(Sheet2!E2,Sheet1!D:D,0))

Getting errors, tried variations, and searched here. Hoping a expert can assist. Thank you tons.

 

[Fluff]

It looks as though the account numbers on Sheet1 are text & on sheet2 are numbers, so try

=INDEX(Sheet1!A:A,MATCH(E2&"",Sheet1!D:D,0))

 

[awiley1]

It looks as though the account numbers on Sheet1 are text & on sheet2 are numbers, so try

=INDEX(Sheet1!A:A,MATCH(E2&"",Sheet1!D:D,0))

That was impressive. You nailed it sir

 

[Fluff]

You're welcome & thanks for the feedback.