Vlookup

[Bluseals]

First off...Thanks for the Birthday wishes....very kind!
Now a favor ..
Please look at the attached spreadsheet. I pulled the data from software and input it into the "Data 830am" tab. Is there a a formula to look into column A and find all the "3PTY" associates and pull the data from column B and place under the System column in the "830am" tab?

Thanks!!
Bluseals

[NBVC]

In a free cell of the destination sheet, e.g. J1:

Please Login or Register  to view this content.

this give count of matches and is needed in next formula

then in A2

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down as far as you need.

Then in B2:

Please Login or Register  to view this content.

copied down and over adjust the indexed range as required.

[Bluseals]

You lost me at "Then B2". B2 is the name column? Is it possible to place the code in the attached spreadsheet and the I can open it and look at what you have done? We all appreciate the advice you give us here! You have helped me more than once look as an "A" player to my boss! I give this website out everychance I get!!! Thank you!

[NBVC]

See attached.

I had assumed you also wanted to pull the corresponding items from the other columns.. that might not be the case... if so, ignore the part where I tell you to enter a formula in B2...

[Bluseals]

Thanks so much!!

[Bluseals]

Why is it that when I copy the forumlas to the rest of the tabs, it does not work correctly. What I am looking to do is be able to paste the raw data into the DATA tabs and receive the specified information into the co-existing tabs.

Data 8:30pm into 830pm
Data 9:30pm into 930pm
so on....

[Bluseals]

This will make it easy for all the other Managers to completed the worksheet. I will attempt to make a macro, where at the end of the day, when all Data is entered, it will copy and paste special all time tabs and delete all Data tabs.

[Bluseals]

I love excel and want my job to pay for training....but am rough with the advanced stuff!

[Bluseals]

Nevermind...I was able to figure it out!!!

[NBVC]

Did you make adjustments to sheetnames and referenced ranges after you copied?

After you copied and adjusted sheetnames and ranges, did you confirm the longer formula with CTRL+SHIFT+ENTER and not just ENTER when you copied down?

Also, you will notice the COUNTIF formula and the long INDEX() formula have a "&CHAR(32) portion. This is because your column A data in the Data sheet has a blank after each entry (it is a special blank) that happens after copying from webpages etc... and you would need to clean those out otherwise (the formula just conforms to the pasted values without having to clean them).. so check that all the column A's from the Data sheets have that extra space.

If you want to clean them out, then you need to then remove the &CHAR(32) from the formulas.

[Bluseals]

So I input some new data into Data 830am and now it will not read past a certain point. Can you tell me why? I have uploaded a new spreadsheet for you look at...Thanks!!

[NBVC]

You need to adjust the formulas... you now have 116 rows...

Go to Edit|Replace and replace $56 with $500 to account for up to 500 rows (make smaller if you can).

[Bluseals]

aww....thanks!!