vlookup not bringing over all data from external woorkbook

T

tech2

New Member
Joined
Mar 8, 2011
Messages
30
I'm using excel 2003

I have an external workbook with blank cells between cells with data and vlookup is only bringing over some of the data. I can't seem to find a pattern.

Thx,

tech2
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
Table Keeps Referencing External Source
Replies
3
Views
217
Alex Blakenburg
A
C
  • Question Question
office 365 VLOOKUP to return not only the cell data, but also the Cell Comment
Replies
2
Views
52
Joe4
Joe4
O
  • Question Question
Extracting data from one sheet to the next
Replies
3
Views
184
Rijnsent
Rijnsent
D
  • Question Question
Embedded data from external links
Replies
2
Views
175
jkpieterse
jkpieterse
A
  • Solved
Automate data export from multiple word tables into excel
Replies
8
Views
181
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,224,602
Messages
6,179,844
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top