In someone else's excel file, in the VLOOKUP function, a Sheet is specified in the range argument, which is not in the workbook. How so?

I

I

Ivan Melnikov2020-06-02 10:05:12

excel

Ivan Melnikov, 2020-06-02 10:05:12

In someone else's excel file, in the VLOOKUP function, a Sheet is specified in the range argument, which is not in the workbook. How so?

=VLOOKUP(F2;Sheet6!B:D;2;FALSE)
At the same time, there is no sheet Sheet6 in the book, and the formula calculates without error.
How can this be?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Andrew, 2020-06-02
@immelnikoff

This means the sheet is hidden.
Hiding and showing sheets and workbooks

Similar questions

A

Alexey Nikolaev2016-02-13 21:00:59

How to write such a condition in Excel? 1Reply

D

Dmitry2016-02-19 10:40:19

How to save images from xlsx with original titles? 2Reply

M

MrLumusss2021-10-05 14:20:17

How to get a pivot table containing rows from source table, one column of which matches records in another table? 1Reply

O

olitaleto2020-07-13 12:45:33

Control declarations of conformity with a macro? 2Reply

J

JohnDaniels2016-03-10 09:32:05

How to write underlined text in xls? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question