ExcelBanter - Help with 2 formulas together

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with 2 formulas together (https://www.excelbanter.com/excel-worksheet-functions/116324-help-2-formulas-together.html)

Areid

Help with 2 formulas together

I want to do a vloopkup and if is not 1 make it appear blank?

Barb Reinhardt

Help with 2 formulas together

How about putting your VLOOKUP within this

=IF(VLOOKUP()=1,VLOOKUP(),NA())

Or replace NA() with "". Just replace VLOOKUP() with your VLOOKUP formula.

"Areid" wrote:

I want to do a vloopkup and if is not 1 make it appear blank?

All times are GMT +1. The time now is 08:25 AM.