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

What is your question?

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

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

what would be the correct category?

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

Try using IF condition @LucasSilva

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

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