i can't understand how to make a success vlook up

  • Thread starter Thread starter Mr Wright
  • Start date Start date
M

Mr Wright

hi,

i'm using microsoft excel for a class assignment and i
can't figure out how to use the Vlookup successfully,
i can bring the vlookup window on my screen but i don't
know how to use it properly

My instruction sheet says: Create a Vlookup in cell E21,
use cell D21 as of Reference and range B7:c16 to return
the name of the item corresponding to amount sold,

Now, what need to know is on the Vlookup command window,
what is the correct way in punching in this information

please help me for i am stuck
 
Hi Mr. Wright,

After trying the Lookup Wizard for the first time, I can
certainly see why you're confused. I was confused and I
sort of know what I'm doing! Forget the Lookup Wizard!
This is the formula it generated:

=INDEX($B$6:$C$16, MATCH(D21,$B$6:$B$16,), MATCH
("Item",$B$6:$C$6,))

Enter this formula instead:

=VLOOKUP(D21,B7:C16,2,0)

Now,here's how it works. You want to find a value in a
range that corresponds to the value that is contained in
cell D21. The range to to search is B7:C16. The value you
want is located in column 2. 0 means that the range is not
sorted. Typically, most people use FALSE instead of 0 as
the last argument. If you use TRUE or 1 for this argument,
if an EXACT match is not found the formula can return the
CLOSEST match.

Suppose D21 contains the value 10. The formula will look
for that value in the range B7:B16. If it's found it will
then look for the corresponding value in the range C7:C16
which is column 2 of the range. If no match is found the
formula will return #N/A which means not available.

Biff
 
Hi Mr Wright! I have just finished an assessment using Vlookup. The
first section wants to know a 'starting point' on which to base the
following 3 questions eg "B19". The second section wants you to find
and highlight the area in a table that contains both Section 1's
reference AND the answer to your question and eg "sheet1!A3:B7". The
third section wants you to insert the number of the column it will find
your answer in eg "2" (not column B). The final question wants you to
insert "TRUE" or "FALSE" - I tried each until it got my answer.

Hope this has helped. Kanga
 
Back
Top