VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

**sumans054** · 06-30-2019, 03:36 PM

Hello All,

I need Cell References. I have data in Table 1 (which is in Sheet1) two Columns ..... These values should look into Table-2 and if a match found then it has to put that Cell Reference into Table-3 and if there is no match found then it was keep 'Not Found' in Table-3. I have written a Macro though I'm not expert and this isn't working for me. Can someone, please check and correct this script. I really appreciate if someone can help me. Thanks in advance!!

And for your reference I'm attaching the workbook and also copying the code which I have written below

Please Login or Register  to view this content.

**bakerman2** · 07-01-2019, 01:40 AM

To get you started.

Please Login or Register  to view this content.

**sumans054** · 07-01-2019, 06:18 AM

Thank you very much Mr.Bakerman2 .... I really appreciate your help and the script is working perfectly as expected!!

**bakerman2** · 07-16-2019, 02:29 AM

You're welcome and thanks for rep+.

VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

LinkBack

Thread Tools

Rate This Thread

Display

VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

Re: Help needed - VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

Re: Help needed - VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

Re: VBA Pull Cell References by Matching Data (Table 1 looks into Table 2)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find all matching unique references in a table and return the highest corresponding date

How to pull headers from a multi-column, multi-row table for a specific cell in the table

Search Table to find exact matchs, then pull data from corresponding cell

[SOLVED] Lookup or index on multiple parameters and pull table heading for matching values

Attempting to pull back all matching values in a 2 column table using INDEX. VLOOKUP?

Lookup data in table and check date and time from 2 different cell references

Matching a Row from Table 1 to a Row in Table 2 (non-numeric), and as a result show a cell

Bookmarks

Bookmarks

Posting Permissions