#1   Report Post  
Samantha
 
Posts: n/a
Default vlookup error!!

Hello,
I am using Vlookup to locate a few products and find out
their sales price, from another excel worksheet
(sales_historic) with a list of all products. In the
bigger excel worksheet(sales_historic), as product may
repeat itself many times, because it was sold many times.
I just need the last sales price of the product. When i
use vlookup function, i geta return of '#REF!'
any ideas, what i should do to get the values and not this.

thanks a lot for any help.
Samantha
=VLOOKUP(A2;sales_historic!C2:C661;16;FALSE)
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

the syntax of a VLOOKUP is
=VLOOKUP(lookup_value, table_with_answer,
col_num_of_required_info,approx_match)
your table array is C2:C661
but you want the answer from column 16 (ie column R)
so if this is correct expand your range to take in column R as well
(C2:R661)

if this is not how your data is set up then maybe VLOOKUP isn't the correct
formula to use to get the last sales price - if you'ld like to let us know
the structure of your data maybe we can come up with a better solution.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Samantha" wrote in message
...
Hello,
I am using Vlookup to locate a few products and find out
their sales price, from another excel worksheet
(sales_historic) with a list of all products. In the
bigger excel worksheet(sales_historic), as product may
repeat itself many times, because it was sold many times.
I just need the last sales price of the product. When i
use vlookup function, i geta return of '#REF!'
any ideas, what i should do to get the values and not this.

thanks a lot for any help.
Samantha
=VLOOKUP(A2;sales_historic!C2:C661;16;FALSE)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup Error mick.smith1964 Excel Worksheet Functions 5 January 13th 05 11:03 PM
Vlookup & Lookup function error Beginner Excel Worksheet Functions 9 January 11th 05 01:37 AM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 06:28 PM
Vlookup #N/A error due to formatting Patrick_KC Excel Worksheet Functions 4 December 21st 04 08:39 PM
#N/A error with VLOOKUP Michelle Tucker Excel Discussion (Misc queries) 4 December 14th 04 02:23 PM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"