This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is anyone aware of a Formula that will vlookup a value "x" number of spaces to the right anywhere in a workbook, not just a range on a worksheet?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
You may use Vstack and 3D reference to combine all the sheet from another workbook into one range for vlookup formula.
=VLOOKUP(A2,VSTACK([Book2.xlsx]PIU:FMS!$A$2:$K$1000),11,0)
Create a 3-D reference to the same cell range on multiple worksheets - Microsoft Support
Thank you very much. Most helpful.
When using vlookup from one workbook to another. Is there a formula that can look in the entire workbook not just in a single sheet?
i.e.
Book 3 B1
=VLOOKUP(A1,[Book2.xlsx]PIU!$A:$K,11,FALSE)
Looks in Worksheet PIU
Book 3 B2
=VLOOKUP(A1,[Book2.xlsx]FMS!$A:$K,11,FALSE)
Looks in worksheet FMS
Is there a single formula that can be used in Book 3 column B to lookup both Worksheets?
Ho Cory
Can you please, elaborate a bit more on your request?
Please provide us with pictures of your data/scenario and the results as expected with the possible formula.
Regards
Jeovany