Hi
I am trying to find a formula where if any one of a range of cells equals a nominated cell's value, values from a different range of cells are displayed.
i.e. If range D2:F2 = H1 then display cells from A2:C2 in cells H2:J2.
I have included an image in case I haven't been able to articulate this well enough.
Any help appreciated!
Thanks
Capture.JPG
Bookmarks