Validation and Vlookups?

jahnosha

Board Regular
Joined
Mar 22, 2011
Messages
53
Hi there,

I am driving myself crazy right now as I built a huge project in XLS 2003.
It is broken down into three components:

1) Individual work sheet each of 5 workers has an individual sheet they enter their clients data into.

2) Master Worksheet- pulls all data from #1 spreadsheets as is.

Note: Master worksheet and individual worksheets are set up the same as far as columns, rows and information in those goes.

3) Summary Sheet: Provides the master worksheet info compiled in a different format, as a summary. one column shows the totals of all number 1 worksheets but the second column is a validated drop down list of the individual clients which uses a vlookup function to pull the individual's information from the master.

HOWEVER, among the list of 30 clients or so, two of them start with the letter N but are different altogether, when I pull one or the other it only pulls the information of the first one. basically, VLOOKUP won't distinguish between N1 and N2 clients and just pulls N1 information for both.

This is something I proposed our company uses and now its not working and I don't know why!

Any suggestions are welcome.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,224,527
Messages
6,179,334
Members
452,907
Latest member
Roland Deschain

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