MS Excel experts, I badly, BADLY need your help!!!?

Question

I have a huge Excel sheet containing the prices of every grocery item we have (over 1,000 rows). I now received another Excel sheet containing around 400 grocery items, but without the prices. My job is to look for the price in the big sheet then fill it in the new one. If I do this manually it would take forever. Anyone know a formula that can achieve this? Thanks guys

Answer 1

VLOOKUP. :)



The table array is the matrix of items and associated prices. The lookup value is the list of 400 items. When you copy down, don't forget to lock in the matrix using the $ sign. (in other words, if the array is a2:b1081, you'll want to type the formula $a$2: $b$1081). The column number is which on eyou want to be displayed, (it'll be 1 or 2), and the range lookup is TRUE or FALSE (FALSE means excel will only look for exact matches).



So an example formula would look like this.



=VLOOKUP(c2,$a$2:$b$1045,1,FALSE).

Answer 2

in case you desire the cellular to be wider, double click on the border of the cellular interior the column header (next to the letter on the right). this could all greater wholesome the cellular width on your content textile. verify you have content textile or the autofit wont artwork in case you desire the words to wrap to the subsequent line, good click the cellular, click format cells, have been given to the alignment tab, and consider wrap text textile. Excel is dazzling! Wait till you study the distinctive cool stuff.

Answer 3

=vlookup()



look on ms office help for instructions. probably your best bet.



set them up on the same file (but different sheets) if you lock the numbers in the () part $F$22 (eg.)



play with it, but it should do what you need

Answer 4

u can press Ctrl+F....dis wld be easier dan dat formulae