excel help

[Philquad]

i cant remember how to do it now

would like to have a dropdown menu in column 1
relevant to the price column next to it

vlookup or cell reference?
i did it yrs ago but with 2003, 2010 i have no idea

[Mods]

Dropdown is under the 'data' heading, then data validation.

You will need to use vlookup. Easiest way is just to search for vlookup under the formulas tab, and it basically guides you through.
Remember to have exactly the same names in the first column.

Cheers.

[Mods]

=VLOOKUP(K10,'Material Data'!A10:H147,J6,FALSE)

That is the exact line from the spreadsheet I am using now.
The K10 is the name of the item (must be the same in the data list).
The 'Material Data'!A10:h147 is the page I have set up with all the prices on. The a10:h147 is the range (top left to bottom right)
J6 is a variable I have, so I can change suppliers. You can just leave this as a column number
False - well it's always false Not really sure why. I've done hundreds of these things, and it's always false I should look up why

Good luck

[Philquad]

it looked more rememberable in 2003
lucky i got your email

[jimmyc]

=VLOOKUP(K10,'Material Data'!A10:H147,J6,FALSE)

False - well it's always false Not really sure why. I've done hundreds of these things, and it's always false I should look up why

It sets wether or not a range lookup is performed.

Range_lookup A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
If FALSE only an exact match will be returned

[lsemmens]

Don't forget that you can declare absolute cell references by placing the $ sign in front of the row or column, too. IIRC true or false at the end of a formula is related to the return value of said formula.

[Philquad]

i used to have the old 2000 office text book
but its missing

this is the file