Excel query

B

BlueSpud

Guest
I am typing to set up a master table of product codes and descriptions in one excel file, and look it up from another file using VLOOKUP. There are 151 rows of products, on lines 5 through to 155. My sales table also has data on rows 5-155. I have the same VLOOKUP statement on each line in the sales file, but blocks of the sales lines are not succeeding in the VLOOKUP, even though it is the same formula as the line above. Any ideas?
 
Edited to remove "preaching to the converted" type advise! Clearly my ability to "cut & paste" is not quite on a par with the the skills of some other contributers!!
 
did you put the $ sign between the bracket and the first part of your formula ?
 
Have you changed the size of the area in the VLOOKUP i.e. do you need to re-define the area which the formula is based on.
 
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
'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.....

Edited by ClubMan to remove extraneous emoticons.
 
BlueSpuds post reposted using plain text radio button setting
(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.....
 
Hi BS,

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
 
You must log in or register to reply here.
Menu
Log in
Register