VBA lookup from another sheet

[muss1210]

Hello Everyone

In Cell C2 i would like it to do a lookup which would work the same as the below vlookup and then repeat until the last row of data in cell C1.

Please Login or Register  to view this content.

I managed to get a vlookup to work if i had the results in P2 for example, but i need the results in C2 so tried using indexmatch but i couldnt get any results to appear.


Thank you in advance

[AliGW]

VLOOKUP and INDEX MATCH are formula functions, but you have posted in the VBA section. You probably don't need VBA for what you want to do, though.

Will you please attach a sample Excel workbook?

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[alansidman]

Here is a tutorial on using worksheet functions in VBA.

http://www.cpearson.com/excel/Callin...ionsInVBA.aspx

[muss1210]

Hello Ali GW

I have a heavy macro based workbook which creates production schedules so i cant go down the manual route, but here is example of what i would like




thank you in advance

[alansidman]

Try this:

Please Login or Register  to view this content.

Then check out the link in my prior post for a clear understanding.

[muss1210]

Thanks alansidman, that did the trick