Hello,
Please bare with me, this is somewhat hard to explain.
I wish to grab a cell value from one sheet and bring it to another based on a previous cell from the same row on the original sheet compared to the column on the second sheet.
For instance
Sheet 1
A 1
B 2
C 3
Sheet 2
B Formula
C Formula
A Formula
Formula should make sheet 2 look like this
Desired Result
B 2
C 3
A 1
please also see attached excel sheet for example
I have gotten pretty close with
=IF(ISERROR(MATCH(A2,Sheet1!$A$2:$A$8,0)),"Missing",Sheet1!B2)
but of course that ends up pulling
B 1
C 2
A 3
which obviously is not what we are shooting for
Bookmarks