Forum Discussion
Solved
Formula Help - Match List
I am in need of some assistance on a formula for a cell. I'll try to explain this without attaching a document. I would be happy to attach the document but this post doesn't allow that. I am tryi...
=INDEX('Sheet 1'!$B$2:$B$4,MATCH('Sheet 2'!$A2,'Sheet 1'!$A$2:$A$4,0))You can try INDEX and MATCH.
Sheet 1:
Sheet 2:
=INDEX('Sheet 1'!$B$2:$B$4,MATCH('Sheet 2'!$A2,'Sheet 1'!$A$2:$A$4,0))You can try INDEX and MATCH.
Sheet 1:
Sheet 2: