Excel formula showing auto number?

We’ve number of style selection and cost, can MY SPOUSE AND I do a new formula in excel as while i type your style number in the column, another column might be shown the number and selling price together
Pertaining to instances, sheet1 A1 (style 1), A2 (price 10), B1 (style 2), B2 (price 20); basically type (style 1) within sheet2 D1, D1 as well as D2 might be shown (style 1) along with (price 10).
Can i do that formula throughout excel

Enter the following formula in Sheet COUPLE OF cell D2:

=HLOOKUP(D1, Sheet1! A1:B2, 2, FALSE)

EDIT:

The right formula provided simply by expletive_xom would certainly work in the event the styles usually are written in cells around column YOUR and selling prices are composed in cells in column B.Then again, the example provided by the asker specifies that this styles come in row 1 as well as prices are developing row COUPLE OF.In this kind of case, HLOOKUP may be the proper function to apply.

sure you may.thats some sort of VLOOKUP() function
so add some more styles into say Model 9
Sheet1 mobile phone A1 to be able to A9 offers 9 distinct styles
Sheet1 mobile phone B1 to be able to B9 get 9 distinct prices

then about Sheet2 cell phone A1 key in Style 1
in Sheet2 cellular B1 copy&paste this specific formula

=IF(A1=””, “”, A1&” plus “&VLOOKUP(A1, Sheet1! A1:B9, 2, 0))

whenever you type inside any in the styles, it can just appear in B1
you may change the particular B9 from the formula to help B2 in the event you only own 2 styles

additionally, i put in the IF() making sure that if people delete Sheet2 A1 consequently its empty…then B1 present blank until buy A1

okay know in the event that works

edit-
proper on waterboy:o).