index match, ..... skip result if blank value ...... jump to next match

**gehawk** · 08-08-2013, 04:29 AM

Hi guys,

I have a question,

I have a list of data for example:

columnA columnB
Ak yellow
Bk
Ck green
Dk red
Ek purple
Bk black

Imagine in cell D1 I have "Bk" and I want to index match it on column A and B. the index match will automatically retreive the first value in column B attached with BK being empty thus retreive value "0".

What I would like to add to my formula is an "if result is blank jump to next match"

What should I add to this formula :

Please Login or Register  to view this content.

Thanks!

**martindwilson** · 08-08-2013, 04:40 AM

=INDEX(B1:B10,MATCH(1,INDEX(INDEX(A1:A10="bk",0)*INDEX(B1:B10<>"",0),0),0)) will give the first non blank result
with your regional settings
=INDEX(B1:B10;MATCH(1;INDEX(INDEX(A1:A10=D1;0)*INDEX(B1:B10<>"";0);0);0))

**gehawk** · 08-08-2013, 04:42 AM

Thanks for your help!

index match, ..... skip result if blank value ...... jump to next match

LinkBack

Thread Tools

Rate This Thread

Display

index match, ..... skip result if blank value ...... jump to next match

Re: index match, ..... skip result if blank value ...... jump to next match

Re: index match, ..... skip result if blank value ...... jump to next match

Thread Information

Users Browsing this Thread

Similar Threads

Match string in one column, return value in same row, skip rows that down't match

[SOLVED] Index Match if result is not something

Index / Match / Jump to next column if value already used

Index/Match/Match. Formula looking veritcal and horizontal headings to find a match

Index Match: Show blank instead of #NA for no match

Bookmarks

Bookmarks

Posting Permissions