help with if statement

[ariel20029]

Hi all,
I am having trouble with a nested if statement. I have several columns of data I need help with a formula that will look at the first column of data in column B if nothing found then go to Column C if nothing go to D if nothing go to E. If all the columns are blank then pull value from column G.

Example:
B C D E F G Formula result
1.00 1.00 5.00 1.00
BLANK 2.00 2.5 2.250 2.00
BLANK BLANK 4.00 3.00 3.00 4.00
BLANK BLANK BLANK 7.00 5.00 7.00
BLANK BLANK BLANK BLANK 10.00 10.00

I was having trouble with the logic of the formula. I am probably overthinking it, Any help would be appreciated.
( the different columns are pulling list price information from different sources and can have different values) . I have the columns data in the pecking order needed for the results).
thanks,
Sharon

 

[Joe4]

To pull the first value in the row in the range B1:G1, use this formula:

=INDEX(B1:G1,MATCH(TRUE,INDEX((B1:G1<>0),0),0))

For an explanation, see: https://www.extendoffice.com/docume...-first-last-non-blank-cell-in-row-column.html

 

[Special-K99]

=INDEX(B1:G1,MATCH(TRUE,INDEX((B1:G1<>""),0),0))
and copy down the column

 

[ariel20029]

Wow -- thank you so much- I will give it a try tomorrow.
Sharon

 

[ariel20029]

Hi- Worked Perfectly thank you so much for all of your help.
Sharon

 

[Joe4]

You are welcome.
Glad we could help.