How to combine formulas in Google sheets?

A

A

Andrey Filimonov2017-12-04 18:41:14

Google Sheets

Andrey Filimonov, 2017-12-04 18:41:14

How to combine formulas in Google sheets?

Hello, please tell me how it is possible to combine the HPR and ESLIOSHIBKA formulas into one? Now like this

Sheet 7 of this file

=ГПР(A14; $A$1:$N$2; 2; ЛОЖЬ)
=ЕСЛИОШИБКА(A15; "")

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Kiselyov, 2017-12-04
@fil_and

= IFERROR (HLOOKUP(A14, $A$1:$N$2, 2, FALSE), "") access to "Sheet 7 of this file" is closed, so the solution may not be accurate.

Similar questions

S

Sega6662019-05-04 14:22:38

Availability in stock - order = balance? 2Reply

A

Artem Morozov2019-05-06 06:51:55

How to take into account the range of columns SUM calculation when creating new rows? 1Reply

N

Noir2019-05-10 11:15:03

How to make a select from a column from a cell that contains a date in another cell with a date? 1Reply

L

lualte2021-01-15 10:37:47

How to add contacts from a telegram group to excel tables? 1Reply

A

aminodovborisov2021-01-21 12:54:36

How to get date format from date string and time string? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question