Excel formula question (because I'm a dumbdumb)

[QueBert]

I don't know how to word what I'm trying to do, so I can't find any help on Google. I'm not asking for help with the formula, as I'm sure it'll be more involved than a quick 1 line reply. I'm asking for someone to point me to a tutorial that breaks it down. I'll try to explain it simple. I'm making a drop down, that's easy enough. But I want the drop down to link to a different cell. I have around 50 items I want to be able to select from a drop down where the item will auto populate the price cell with the price. Here's an example of 1 thing.

A1 - 5lb bag of Pepperoni
B1 - $29.99
A2 - 10lb bag of Pepperoni
B2 - $54.99

Then in another sheet there's the drop down, and whatever they select will also update the adjacent cell. So since I'm dumb, I don't even know the right way to do this, but I'm assuming this would work, and I'm assuming it should be doable with some sort of formula. What the hell would this formula be called so I can Google it and figure it out?

 

[pete6032]

You want data validation to create the dropdown and vlookup to look up the prices.

 

[IronWing]

Something like this?


Read up on @VLOOKUP().

Also read up on named ranges. This makes VLOOKUP() much more intuitive to use and easier to remember what you did.

 

[pete6032]

Something like this?
View attachment 98266

Read up on @VLOOKUP().

Also read up on named ranges. This makes VLOOKUP() much more intuitive to use and easier to remember what you did.

What, VLOOKUP('Sheet 2!') not doing it for you?

 

[sdifox]

What, VLOOKUP('Sheet 2!') not doing it for you?

Well named range allows you to have one sheet for all the different lookup tables and make it manageable.

 

[IronWing]

Well named range allows you to have one sheet for all the different lookup tables and make it manageable.

Yep.

OP: Start with understanding named ranges before working on @VLOOKUP() or even data validation lists.

 

[pete6032]

Well named range allows you to have one sheet for all the different lookup tables and make it manageable.

I kinda like the data validation to be on a separate tab so I can easily see what the dropdown options are. Makes it easier to add options as well IMO.

 

[Exterous]

Nvm

 

[QueBert]

Something like this?
View attachment 98266

Read up on @VLOOKUP().

Also read up on named ranges. This makes VLOOKUP() much more intuitive to use and easier to remember what you did.

Nope, but thanks for pointing out VLOOKUP, I watched a YT video and I'm pretty sure with some research I can figure out a way to use it to do what I'm after. Just so I'm more clear what I'm trying to do.

sheet 1 has 2 columns, items in a drop down and prices. The prices for the items will always be in the next column over.
sheet 2 has a drop down for the items in sheet 1, and when I select something, it will populate in the price of the item in the adjacent column. All I'm asking here is is this something that VLOOKUP can be used for? I'd hate to go read up in to for an hour only to find out it's not what I need lol.