Skip Error to return cell value

**pauldaddyadams** · 01-30-2019, 04:47 AM

Hi

I have 5 columns (H:L) which contain basic vlookups to external sheets in my master file.

What I would like please is in column M a formula which looks through each column and displays the cell which contains a non error.

I have provided an example.

Can anyone help please?

**Bo_Ry** · 01-30-2019, 04:53 AM

Please try at M4 and drag down

=LOOKUP("z",H4:L4)

**pauldaddyadams** · 01-30-2019, 05:01 AM

Hi,

It worked great for the majority of may data but I had issues with some.

In the attached I have a car reg - it didn't like it with this reg.

Any ideas why?

**Bo_Ry** · 01-30-2019, 05:07 AM

The lookup value need to be more that lookup table

"ZO" is more that "Z"

Please try

=LOOKUP("zzzz",H10:L10)

or for sure

=LOOKUP(CHAR(255),H10:L10)

**pauldaddyadams** · 01-30-2019, 05:22 AM

Thank you! I managed to get it to work with "zzzz" but not the last formula

Skip Error to return cell value

LinkBack

Thread Tools

Rate This Thread

Display

Skip Error to return cell value

Re: Skip Error to return cell value

Re: Skip Error to return cell value

Re: Skip Error to return cell value

Re: Skip Error to return cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] skip 44 rows, name, skip 44 rows, return name

[SOLVED] VlookUp must return value where first entry is and skip the empty cells

[SOLVED] Return value cannot skip blank cell

Concatenate, Skip Blanks and Carriage Return only after non-blank

How to skip blanks in col B to return list items from col A (Example Attached)

Have cell return 0 if the source cell has the value 0 or an error, return 1 otherwise

If cell contains blank, skip cell (Run Time Error 13)

Bookmarks

Bookmarks

Posting Permissions