Vlookup formula to skip blank cell and give the next value

**Kehjz** · 03-19-2013, 04:05 AM

Hi all,

Is it possible to tell vlookup to ignore blank and instead, give me the next value?

Attached is the questions and desired output I wanted.

Thanks all in advance.

keh

**Wormsek** · 03-19-2013, 04:13 AM

Try like this:

Please Login or Register  to view this content.

**Fotis1991** · 03-19-2013, 04:15 AM

One way could be this.

=IF(INDEX(B7:B11,MATCH(F7,A7:A11,0))=0,(INDEX(B7:B11,MATCH(F7,A7:A11,0)+ROW(A1))))

**Kehjz** · 03-19-2013, 05:56 AM

Hi, thanks, so if i want to skip value less than 5, I only need to the change "" to "<5", right?

Thanks for the answer!

**Wormsek** · 03-19-2013, 06:06 AM

Have you try it

Re: Vlookup formula to skip blank cell and give the next value