B

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

B

S

C

did you put the $ sign between the bracket and the first part of your formula ?

M

B

=VLOOKUP(B5, 'Q:\ Data\[Products.xls]Products'!$A$5:$ B$500, 2, 0)

The syntax of the table array

'C:\ Data\[Products.xls]Products'!$A$5:$ B$500

I copied from another work sheet.

The area has remained the same.....

ajapale: Just tweaked the plain text.....

A

(sorry BS but I was fixing it at the exact same time as youself)

Not sure I understand exactly what you mean caroerin. Here is the formula:

=VLOOKUP(B5, 'Q: Data\[Products.xls]Products'!$A$5 B$500, 2, 0)

The syntax of the table array =VLOOKUP(B5, 'C Data\[Products.xls]Products'!$A$5 B$500, 2, 0) ('Q Data\[Products.xls]Products'!$A$5 B$500) I copied from another work sheet.

The area has remained the same.....

A

Ive moved this to the IT forum and am going to think about it over lunch. What version of Excel are you using. I think this might be related to the fact that vlookup works slightly differently depending whether you are lookin up within a workbook or whether you are looking up from an external work book.

ajapale

B

ajapale

I am using Excel 2002.

I am using Excel 2002.