Need to improve (solve problem) with the following formula...
=IF(VLOOKUP($A9,'[STD PRICE L_2014Q4.xls]Products'!$A:$P,COLUMN(J9),0)=J9,J9,'[STD PRICE L_2014Q4.xls]Products'!$J8)
So basicly I need to a find/cross ref the code in Cell A9 in another file (STD PRICE L_2014Q4.xls)
and if it finds it matches, show text in Cell J9 otherwise show the text that appears in matching cell in column J of 'STD PRICE L_2014Q4.xls'
If that makes sense?
Can't use cell references from STD PRICE L_2014Q4.xls as they do not always run in the same order..
Can anyone help?
=IF(VLOOKUP($A9,'[STD PRICE L_2014Q4.xls]Products'!$A:$P,COLUMN(J9),0)=J9,J9,'[STD PRICE L_2014Q4.xls]Products'!$J8)
So basicly I need to a find/cross ref the code in Cell A9 in another file (STD PRICE L_2014Q4.xls)
and if it finds it matches, show text in Cell J9 otherwise show the text that appears in matching cell in column J of 'STD PRICE L_2014Q4.xls'
If that makes sense?
Can't use cell references from STD PRICE L_2014Q4.xls as they do not always run in the same order..
Can anyone help?