vlookup - need to grab multiple rows of unique data; instead of the same data over and over

[clrichert]

Hello Everyone!

I am trying to pull specific data (text and numbers) from multiple worksheets that are all in the same workbook and put it all inside one worksheet tab (like a dashboard). So far I have been unsuccessful. I know that vlookup is basically pulling the first lookup value it see's over and over again.

Here is an example:

From B1:O9 I have everything I need. Below that is where I am having issues.

This is the formula I am using:

If the value is returned "0" then I need a "0" if the value is returned blank then I need the value to be "-" which is the reason for this formula.

I am open to using VBA, but I am still a newbie and don’t really know where to begin.

Thank you for the help!

The cell that says "Lookup Name" is A2.

<tbody>
</tbody><colgroup><col></colgroup>

March April May June July August Lookup Name Location AX PX AX PX AX PX AX PX AX PX AX PX Comments K-Barn 115.1 Top - - - 26.4 - 37.3 - 13.2 - 14.1 - - Bring to next boL Location CL BV CL BV CL BV CL BV CL BV CL BV Comments Bottom - - 88.05 2.535 95.34 2.06 137.8 2.965 110.7 3.074 12 141 out of range-reduce Location Black Green Black Green Black Green Black Green Black Green Black Green Comments Bottom - - 1 1 1 1 2 1 0 2 1 1 - Location February March April May June July Comments Top 1.00 MPY 0.69 MPY - - 0.14 MPY 0.36 MPY Talked about last year Action Items Date Submitted Follow up 6/27/2017 Bring up to team next months objective Completed 6/27/2017 Bring up to team next months objective Completed 6/27/2017 Bring up to team next months objective Completed Con Report Name Type O, W, TF Run Target/day Actual/day Chem/Variance % Monthly Cost Cost Comments EXP2 Green TF 100 30.40 32.00 5% $ 258.61 $ 1.15 EXP2 Green TF 100 30.40 32.00 5% $ 258.61 $ 1.15 EXP2 Green TF 100 30.40 32.00 5% $ 258.61 $ 1.15 Totals Treat Report Name Target gal/Stop Actual Frequency Vol Variance % Cost $/BOE Comments EXP1 23 2 21 1/M 2 12% $ 27.44 $ 9.35 Bad Month EXP1 23 2 21 1/M 2 12% $ 27.44 $ 9.35 Bad Month EXP1 23 2 21 1/M 2 12% $ 27.44 $ 9.35 Bad Month Totals <colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 6997;"> <col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 2787;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2133;" span="12"> <col width="416" style="width: 312pt; mso-width-source: userset; mso-width-alt: 11832;"> <tbody> </tbody>

<tbody>
</tbody>

 

[pbornemeier]

Please provide some examples of your Vlookup formulas and be sure to include the cell they are in.
Explain what data you want to retrieve from what worksheets/ranges to what ranges.
You can use Excel Jeanie (see link in my sig) to post portions of your workbook.