URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP

Sami

Board Regular
Joined
Mar 4, 2002
Messages
122
I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:

=VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)

However although this should work i dont know why it keeps coming back with #NA
????
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
If your range names are correct then the vlookup is accurate provided that the item is actually in the list.

Without seeing the actual data it is a little tough. Your syntax is correct. ASsuming, again, that your range names are all inclusive and the item is in the list.

PJ
 
Upvote 0
I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:

=VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)

However although this should work i dont know why it keeps coming back with #NA

Check your syntax and datatable.

See Help for Vlookup.

Is id code in column 1 of ProductTable?
What column do you want returned?
Is the table named correctly?

You would receive a much better answer, if
you showed a very concise example of your
information.
 
Upvote 0
Is id code in column 1 of ProductTable?
no column 3 (c)

What column do you want returned?
column 1 (a)

Is the table named correctly? I named all the columns the same as their headings and the Products table is called ProductTable

Ive got a Sales workbook set out like this:

Column A = Sale Date, Column B = Product ID,

Column C = Product Name, Column D = Price,

Column E = Quantity, Column F = Cost.

Ive got a Products workbook set out like this:

Column A = Product Name, Column B = Description

Column C = Product ID, Column D = Price,

Column E = Supplier.

In the sales workbook when the product ID is entered i want a VLOOKUP to lookup in the products workbook its name??? plz help
 
Upvote 0
If what you are searching for is not in the first column, then a straight vlookup will not work.

You would wnat to integrate two functions - index and match. There is a great example in the tips section to do this.

________________
Paul

here is the link to the tip

http://www.mrexcel.com/tip021.shtml
This message was edited by Paul-Johnson on 2002-03-16 09:49
 
Upvote 0
what do u mean not in the first column?? this can be done no matter what the column you are searching for is?? cant u??
 
Upvote 0
For example if you had a data range like:

Column A Names
Column B Age
Column C State

The only way you could use a vlookup would be if you searched by name for age or state.

If you wanted to search a list by state and return the name or age you would have to either rearrange your data or use the index/match function.

PJ
 
Upvote 0
but the heatcote book doesnt do that and it works????

can you tell me how to make it work. i gave all d data :( and im really pushed for time!
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top