I have a stock profiling spreadsheet where I am pulling together a summary based on several system generated spreadsheets. One called 'Super' which has most of my stock info and the other called 'Sales' which has a sales history in.
Column A has part codes as supplied by my suppliers and column B looks this up in the 'Super' sheet to return our internal part code.
Standard formula is
=IF(ISNA(VLOOKUP($A2,super,6,FALSE)),"",VLOOKUP($A2,super,6,FALSE))
which is in column B
However later in column L I am trying to return the sales figure for this product using the internal part code returned by the above formula in column B
I'm using this formula
=VLOOKUP($B2,sales,10,FALSE)
but I keep getting N/A. When I replace the $b2 ref with an actual part code it works OK
Any ideas?
Thanks
ROb
Column A has part codes as supplied by my suppliers and column B looks this up in the 'Super' sheet to return our internal part code.
Standard formula is
=IF(ISNA(VLOOKUP($A2,super,6,FALSE)),"",VLOOKUP($A2,super,6,FALSE))
which is in column B
However later in column L I am trying to return the sales figure for this product using the internal part code returned by the above formula in column B
I'm using this formula
=VLOOKUP($B2,sales,10,FALSE)
but I keep getting N/A. When I replace the $b2 ref with an actual part code it works OK
Any ideas?
Thanks
ROb