I need a function that refereces according to specific value.
For example:
A B
1 Job #=0451 Reference=='[BG-1.orig.0451.xls]BG-1p1'!$F$34
2 Job #=0452 Reference=='[BG-1.orig.0452.xls]BG-1p1'!$F$34

Any suggestions?