im not sure that will work it will mess up the rest of the formulas and results


"cjbarron5" wrote:

can you use the vlookup function to return a value by looking at 2 diffirent
sheets?
I have a formula
=IF(ISNA(VLOOKUP(C18,TABLE1A,2,FALSE)),"",VLOOKUP( C18,TABLE1A,2,FALSE))
this is part of my invoicing on my invoice sheet.....................so I
type an item # in one column and the formula brings up the description in
another column. the formula is looking at my inventory and I would like to
seperate my inventory from my billable operations which are listed on the
same page right now but I want to seperate them