VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I need a little (large lots) of help with an asignment Most of the ACCESS and Word sections are done, but I am stuck in EXCEL. I have three worksheets, Customers, Stock, and Ordrs. I now have to make a summary sheet and get all this information onto it. The big problem is the second last part of this assignment. I have to use the VLOOKUP() function to obtain data from two of the three sheets. The information required is from Customers and Orders. The required info - Name (First and Last which are in seperate columns in the sheet), Address, City, Phone number, description of stock item), Cost price and selling price. All these are in seperate columns.
I have tried using the VLOOKUP function, but can't get it right. The best result I have had so far is only one name came across. When I used the fill handle, the same name appeared four times, then #NA. Another result gave me an exact copy of a few items, but not in the correct order (Wrong address for the names.)

What am I doing wrong.

Help please.
 
Ian,

First step would be to post the formula that you're trying to use.

By the looks of your results, I would guess that your lookup tables
aren't in order. Use the "False" option at the end of the vlookup.

=Vlookup(what,where,index,False)

John

Ian said:
Hi. I need a little (large lots) of help with an asignment Most of the
Click to expand...
ACCESS and Word sections are done, but I am stuck in EXCEL. I have three
worksheets, Customers, Stock, and Ordrs. I now have to make a summary sheet
and get all this information onto it. The big problem is the second last
part of this assignment. I have to use the VLOOKUP() function to obtain
data from two of the three sheets. The information required is from
Customers and Orders. The required info - Name (First and Last which are in
seperate columns in the sheet), Address, City, Phone number, description of
stock item), Cost price and selling price. All these are in seperate
columns.
I have tried using the VLOOKUP function, but can't get it right. The best
Click to expand...
result I have had so far is only one name came across. When I used the fill
handle, the same name appeared four times, then #NA. Another result gave me
an exact copy of a few items, but not in the correct order (Wrong address
for the names.)
 
Back
Top