I have a spreadsheet with formulas and some data may give as "# N / D"

Help
1

I have a spreadsheet with formulas and some data may give as “# N / A” in column B, in which case it is necessary to get the information from column C before these formulas are processed.
Dados Dashboard Outbound.xls (173.5 KB)
the data I need to get is on the Ass Placa tab

2

What is your question?

3

I need to get as C information but only as cells that give "# N / A

4

Do you want to ask this in Portuguese in the right forum category so you can explain better?

5

what would be the correct category?

6

Can you post the formula you have @LucasSilva?

I hope it is a vlookup or whatever, you can simply use it as

If(vlookup formula, column C range) , so if the value is null, it will write the C column value

7

Dados Dashboard Outbound.xls (173.5 KB) yes is a vlookup

8

Try using IF condition @LucasSilva

If the value is there, write it to B else, write the value of column C

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.