I need a formula that looks up a certain value in a range and return a value in the corresponding row.
In Sheet 2 A1 I have VAN, in Sheet 1 row B I have varies cites, VAN, TOR, MTL, SAS.
The formula would need to look up any VAN Sheet 1 Row B and return the value in Row E.
For example if in Sheet 2 B4 I have VAN, then I need to return E4 to Sheet 2.
Now there are going to be many VAN's which is why a Vlookup wouldn't work, is there a way to return all the Column E cells that have a have VAN in Column B.
So on Sheet 2 it would look similar to this
VAN
1VANCLG1
1VANCLG2
1VANCLG3
1VANCLG4
1VANEDM1
1VANKEL1
1VANMTL1
1VANMTL1
1VANSAS1
1VANSAS2
1VANTOR1
1VANTOR2
1VANWPG1
So the formula would need to be in Sheet 2 Cells A2-A50
Bookmarks