How do I change the path in single quotation marks in vlookup to a dynamic reference?

It's best to extract data in one file, multiple workbooks are prone to problems.

The formula is:=vlookup(b3,indirect("'e: Personnel Payroll [Guangzhou store"&$a$1&".

d17"),2,0)

But it's really not suitable for doing such a thing, n worksheets still have to be opened, and in case there is a little change in the file name, worksheet name or inconsistency, it will lead to no accounting!!

If the file computer is slow, it should be your accounting method problem, which is caused by too many invalid traversal accounting formulas!!

Modify the original formula to:

vlookup(b3,indirect("'e: Personnel Payroll [Guangzhou store"&a1&"."&b1&"Payroll. xlsx] employee salary scale'!a6:d17"),2,0)

Both a1 and b1 can be modified.

Or. vlookup(b3,indirect("'e: Personnel Payroll [Guangzhou Store 2019"&"."&b1&"Payroll. xlsx] employee salary scale'!a6:d17"),2,0)

Only b1 can be modified

indirect function.

Specifically, the salary scale ---17"),2,0)

The position of the two ellipses, let's add it.

To be honest, without figuring out what you're talking about, there is no problem with the formula and application, and there will be no double quotes.

a b c d e f

ABCD as a lamp ABC 12 12

Input format error.

Tool: Excel2010

=vlookup(b2,[workbook2]sheet1:!$a$1:$b$6,2,0)

Remove the extra parentheses before 2 and add a 0 or false before the last parenthesis to indicate an exact query.

The formula is changed to: =vlookup(a2,[workbook2]sheet1!$a$1:$b$6,2,0)

Problem analysis: 1. The search value should be A2;

2. There is an extra parenthesis after $b$6; , there should be a parameter after it, 2,1) or 2,0), 1 is an exact, 0 is an exact lookup.

More than half a parentheses. Just remove the one in front of the last 2.

Cells cannot be referenced in the array format, you are in the formula"b2"Because there are quotation marks before and after, it is a text"b2", not cells"b2"。

Change the formula to =if(i4=0,b2,vlookup(i4,,2,0)).

Excel does not support the writing of questions, in fact, the formula for asking questions is only three conditions, just use the if function.

The formula is modified to:

if(i4="","",if(i4<1,b2,if(i4<2,,If you must use the same usage as the question, add an if function, and separate the part corresponding to b2 first, formula:

if(i4="","",if(i4<1,b2,vlookup(i4,,2,0)))

When the above two formulas add i4 to be blank, the formula also returns the blank judgment.

Can you get rid of the quotes and spaces in the table with hidden quotes and spaces?

If you can't get rid of it, try the last parameter of vlookup and set it to true.

Use **Instead**Instead**.