VBA - Index and Match

[jyellis]

Excel 2010
Report Workbook: Col A Wells; Col B Amount

Frac Wells Workbook: Col A Frac Wells; Col J amount

In Report workbook if Wells exists in Frac Wells workbook then copy col J to Report workbook Col B; if no match leave empty.

I was trying to do like an index match function.

I got started with this, but my frac_wells and Report_Tbl variables were always "=Nothing"

Please Login or Register  to view this content.

[TMS]

We'd have a better chance of diagnosing the problem with some data ... like, in a workbook ...