Function that will return the next cell to the right if the 1st cell is blank?

[justineeds]

2463.7 2451.6 2444.5
2451.6 2444.5 2431.3
2444.5 2431.3 2436.3
2431.3 2436.3 2412.7
2436.3 2412.7 2417.9 2380
2412.7 2417.9 2380
2417.9 2380 2366.2
2380 2366.2 2349.1
2366.2 2349.1 2373.9
2349.1 2373.9 2336.9 2335
2373.9 2336.9 2335

I have pasted an example of my data above.
Basically, I want a formula that will return the value in column A, but if this cell is blank, will return the value in column B, and if B is also blank, will return the value in column C etc.
I have five potential columns of data, and I want it to return the first, and ignore any that come after it.

If anyone knows how to do this I would really appreciate the help!!

Regards

[NBVC]

Try something like:

=INDEX(A2:E2,MATCH(TRUE,INDEX(A2:E2<>"",0),0))

copied down

where A2:E2 is first range

[justineeds]

Thanks, that returns the value in Column A if there is a value in column A, but if column A is empty, I want it to return the value in column B, or C, or D, or E - depending on which of them is the first with a value in it.

Regards

[NBVC]

That formula should do just that.... are the cells truly empty? Or are there spaces.. (spacebar entries).?

[Shampoo Monkey]

Hey justineeds,

I tested the formula and it works like you described. If there is a value in A it returns A. If the value of A is blank, then it returns the next column that is not blank. B, C, D or E to cover your 5 columns of data.

What is in your A cell? If it is a formula that produces " ", then try this:

Please Login or Register  to view this content.

[justineeds]

That makes sense, I have a space in my 'blank' cells. I removed the spaces, and this worked perfectly. Thanks very much for your help!!

Regards