VLOOKUP - Skip if blank

[kingn8link]

Having trouble figuring this out, and I'm new to this. In fact, this is my first foray into the world of Excel.

=IFERROR(VLOOKUP(A2,$E:$F,2,FALSE),A2)

​

Using this formula in column B, I want to return the data from column F based on the info entered in A. Additionally, if A returns an error, then I am duplicating the value of A into B.

However, I also want the formula to ignore Blank cells in A. So B should only contain returned values, or duplicate values from A. Currently, it displays a 0 when no data is entered into A when it needs to be blank.

I'm wondering if the formula needs to be nested within another formula, or if I'm approaching this the wrong way.

Any help is appreciated!

 

[Joe4]

Welcome to the Board!

Try this:

[COLOR=#333333]=IF(A2="","",IFERROR(VLOOKUP(A2,$E:$F,2,FALSE),A2))[/COLOR]

 

[kingn8link]

Perfect. That works. Thanks so much!

 

[Ken Cowen]

Not sure exactly what you want, but, if there is a match for the value in A2 somewhere in column E, the formula should return the value from that same row in column F (row of the first instance of an exact match of the value in A2). If there is no match,the VLOOKUP formula will return and error, which will be replaced by the value in A2.

Ken

 

[Joe4]

Perfect. That works. Thanks so much!

You are welcome!