Hi all,
I have tried both vlookup and index/match formulas to pull data and it keeps pulling the first match each time.
Example:
Table:
Network Engineer I
Network Engineer II
Network Engineer III
System Engineer I
System Engineer II
System Engineer III
My formula is -
I have tried both vlookup and index/match formulas to pull data and it keeps pulling the first match each time.
Example:
Table:
Network Engineer I
Network Engineer II
Network Engineer III
System Engineer I
System Engineer II
System Engineer III
My formula is -
=VLOOKUP("*"&C37&"*",'Sheet 1 GSA'!$B$2:$L$40,2,FALSE) and also used -
|