Question

how to use vlookup in excel to find this?

Suppose someone comes into your shop with $8.00 and want Item Unit Sell Unit Cost Pencils 2.79 $ 1.99 to buy something. You wish to Ilookup the best thing (most Pen Sets $ 6.99 4.99 expensive thing they could afford) for that amount of money. Write a lookup function that performs that task $ Clipboards $ 6.99 4.99 $ Binders 8.99 12.59 HINT: You will need to modify the table in order to do this!! $ Pen 27.99 19.99 70.00 $ Desk $ 50.00 Your answer

Answer 1

First of all modify the table given.

Where the 1st column should be the unit sell then 2nd item n 3rd unit cost.

Now in the cell where you need answer....

=vlookup(lookup_value,table_array,col_index_no,true/false)

Now for lookup value...select the cell left to the answer cell where 8 is given

For table array select the table given to us bt not to cover thr headings(ie. Unit sell,item or cost)

For col_index_no you have to type 2,as the item list is in the column no 2 in the selected table

And at thr last select TRUE

It is very simple once you learn it,keep calm and follow the steps.

f satisfied plecase give4our valuable L1kE need more Commeut ρχplonation. are here we