ICT Project: Vlookup and dropdown box

  • Thread starter Thread starter ginja
  • Start date Start date
G

ginja

Basically, i have a big problem, i have to hand my implementation i
tomorrow for my project but i'm stuck on a vlookup formula.

The equation I have used is: “=VLOOKUP(product1,products,4)” (wit
product1 being the drop-down box, products being the selected tabl
from ‘products’ sheet 9with all data), and 4 being the 4th column o
that table (product price) which I wish to show in cell G28. However
this equation returns a response of “#NAME?”. If I provide a cel
reference to the drop-down box, and input that cell reference so tha
the equation is now: “=VLOOKUP(G24,products,1)” it returns with “#N/A”


Am i using the correct function, and if so could someone return
better equation or some tips..i have been searching other posts simila
to this but they are no use to me at the moment!

If it helps i could attach spreadsheet but it is fairly large at nearl
4mb
 
thanks, but it still returns #N/A. The 'products' is defined as the dat
from the products sheet (like a name instead of G!" for example, th
whole table is named 'products'
 
It looks as if you did not define the sheet the product's
table is on. Look again at Franks answer,
=VLOOKUP(G24,'sheet1'A1:D1000,4,0).
If the Sheet is name Products and the table is named
Products then =VLOOKUP(product1,'products'!products,4,0)

Charlie O'Neill
 
Hi
didn't see your reply but I forgot the '!' in my formula
=VLOOKUP(G24,'sheet1!'A1:D1000,4,0)
replace sheet1 with your actual sheetname
 
thanks for the feedback, although i didnt use it.

just found out vlookup doesnt like it when the data is not in ascendin
order, and everything is now running smoothly!

i'm a happy ma
 
Hi
good to hear it works for you. Just as a addition. If you set the forth
parameter of VLOOKUP to zero (or FALSE) the lookup range does not have
to be sorted. Without this parameter a sorting is required
 
Back
Top