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:
This looks to have worked perfectly. Is there an additional part of this formula (or a conditional format) that will leave a cell blank if nothing is selected for X?
=IFERROR(INDEX('sheet 1'!$B$2:$B$4,MATCH('sheet 2'!$A2,'sheet 1'!$A$2:$A$4,0)),"")
You can try this formula. The INDEX and MATCH formula is wrapped into IFERROR.
- Simple solution worked great. You're awesome. Thank you very much for your help.
