How to type a name in one column and get an amount in the next

I have 7 product names that I want to type into column G and have them automatically populate a specific dollar amount in column H based on the name I typed in G. I have no clue where to start to make that happen.

attach a sample file with names and amounts in others columns, we will hide them

"We would love to help you with your question, but 1st, please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertese, they might only open those threads. also, searching for ""help"" will not turn up too many results that will benifit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"

Thanks

i would suggest you put the names and amounts in a small table somewhere, and then use a vlookup() in H, referencing G based on that table

=vlookup(G1,H1:I&,2,false)

=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match


have 7 product names that I want to type into column G and have them automatically populate a specific dollar amount in column H based on the name I typed in G. I h

I think http://www.contextures.com/xlFunctions02.html might help.

see the attached