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

Open the book with the table on the sheet with the table
Start a new workbook for testing
In A1 enter a valid item#
Type =Vookup(A1,
Now, with out ending the formula, open the Inventory book and use the mouse
to select the whole table
The Formula Bar reads =Vlookup(A1, some-flile-name, some-sheet-name!A1:C200
Type a commas and add the 2, FALSE
Now click the green checkmark in the Formula Bar area. Did it work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"cjbarron5" wrote in message
...
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

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