IF and VLOOKUP

[ragavisr94]

Hello,

I want to perform an if and vlookup on the below requirement.

My column A in Sheet A1 is data validated from another Sheet A2 column A.
The column B in Sheet A1 is a vlookup from Sheet A2, corresponding to the value of column A in Sheet A1.
I should be able to paste into the column A, only with valid data from the Sheet A2 column A --> if it is a wrong value then it should show that it is invalid in column B of Sheet A1.

How do I achieve this?

 

[mrshl9898]

Sounds like =IFERROR(your current VLOOKUP,"Invalid")

 

[ragavisr94]

I got it. I wanted to give the blank to be blank, else it was showing invalid with the above formula.