Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need a formula that it will look at the number in column A and see if it is larger than the number in column B, if so pull the number in column C. The caveat is that I need it so if the number in Column C is less than the number in Column B, i need it to go to the next row then the next row until it is larger than the number in Column B
Solved by G. H. in 54 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 29/06/2018 - 02:13
Do i need to input an example?
Excelchat Expert 29/06/2018 - 02:14
Hello Welcome to Gotit pro,we are always glad to help you. May I ask how may I help you?
User 29/06/2018 - 02:14
i need help creating a fomrula
User 29/06/2018 - 02:14
formula*
Excelchat Expert 29/06/2018 - 02:14
ok
Excelchat Expert 29/06/2018 - 02:14
could i have your file so we can check on it?
User 29/06/2018 - 02:14
i cna set the example up
User 29/06/2018 - 02:14
i dont hav ea file
User 29/06/2018 - 02:15
its just an in theory
Excelchat Expert 29/06/2018 - 02:15
ok that much better :)
User 29/06/2018 - 02:15
so in column B
User 29/06/2018 - 02:15
i need a formula
User 29/06/2018 - 02:15
that looks at the number in column A
User 29/06/2018 - 02:16
and then sees which number it matches (or is lower) in column C
User 29/06/2018 - 02:16
and pulls column D
Excelchat Expert 29/06/2018 - 02:16
you want to look up the letter corresponding on number 5 right?
User 29/06/2018 - 02:16
sorta
User 29/06/2018 - 02:16
i need it to basically look up the letter
User 29/06/2018 - 02:16
correseponding to when its lower than column C
User 29/06/2018 - 02:16
so in this Cause it will be F
User 29/06/2018 - 02:16
case*
User 29/06/2018 - 02:17
so for the 8 it will be H
Excelchat Expert 29/06/2018 - 02:17
since there is no 5 on column C?
User 29/06/2018 - 02:17
yeah there is no 5 in column C
Excelchat Expert 29/06/2018 - 02:17
ok i get it :)
Excelchat Expert 29/06/2018 - 02:17
just give me a minute to work on this :)
User 29/06/2018 - 02:18
sure
User 29/06/2018 - 02:26
its a tough one isnt it haha
Excelchat Expert 29/06/2018 - 02:27
haha, I'm just near :)
Excelchat Expert 29/06/2018 - 02:27
yes it's quite difficult :)
User 29/06/2018 - 02:27
i was thinking would htis be an array formula
Excelchat Expert 29/06/2018 - 02:27
yes
User 29/06/2018 - 02:34
yeah so in this case that would be correct for the F
User 29/06/2018 - 02:34
but i would need for the 8 to pull H
Excelchat Expert 29/06/2018 - 02:34
yes,
Excelchat Expert 29/06/2018 - 02:34
I trying to work for some formula that will work for all numbers :)
User 29/06/2018 - 02:34
kk
Excelchat Expert 29/06/2018 - 02:35
:)
User 29/06/2018 - 02:35
take your time
User 29/06/2018 - 02:35
i was stumped on this for awhil
Excelchat Expert 29/06/2018 - 02:35
thanks :)
Excelchat Expert 29/06/2018 - 02:49
could you extend again the time? :)
Excelchat Expert 29/06/2018 - 02:50
i'm almost near on the solution :)
User 29/06/2018 - 02:50
sure
Excelchat Expert 29/06/2018 - 02:53
done for the formula :)
User 29/06/2018 - 02:53
may i alter the sitaution
User 29/06/2018 - 02:53
to see if it applicable
User 29/06/2018 - 02:54
in every sitaution
Excelchat Expert 29/06/2018 - 02:54
yes
User 29/06/2018 - 02:54
but this looks really good
Excelchat Expert 29/06/2018 - 02:54
you may try it :)
User 29/06/2018 - 02:55
this is awesome
Excelchat Expert 29/06/2018 - 02:55
great :)
Excelchat Expert 29/06/2018 - 02:55
the first formula that i used was the vlookup
Excelchat Expert 29/06/2018 - 02:55
but instead of the exact match, i changed it a approximately match
Excelchat Expert 29/06/2018 - 02:56
like this one
Excelchat Expert 29/06/2018 - 02:56
VLOOKUP(A6,C:C,1)
User 29/06/2018 - 02:56
i tried attempting that too
Excelchat Expert 29/06/2018 - 02:56
if I used that, the value would be lesser value right?
Excelchat Expert 29/06/2018 - 02:57
after i get the lower value, i used the formula match so i could get the column number of that lesser value
Excelchat Expert 29/06/2018 - 02:58
then after that when i have got the row number of the lesser value, I used the formula index
Excelchat Expert 29/06/2018 - 02:58
and then the row number that i get, i simply add 1 so i can get the next row number after the lesser value
User 29/06/2018 - 02:59
ohhhh
User 29/06/2018 - 02:59
out of curiosity
User 29/06/2018 - 02:59
how greatly would this formula change
User 29/06/2018 - 02:59
if all these numbers
User 29/06/2018 - 02:59
were negative?
Excelchat Expert 29/06/2018 - 02:59
you may right it also :)
User 29/06/2018 - 03:00
haha sorry i meant to say
User 29/06/2018 - 03:01
if it was changed into a negative aspect
User 29/06/2018 - 03:01
so like for -4
User 29/06/2018 - 03:01
i need it to pull D
User 29/06/2018 - 03:01
dont worry if this will take to olong
User 29/06/2018 - 03:01
i will take it from here if its not a quick qnaswer
Excelchat Expert 29/06/2018 - 03:01
ok wait, i will check :)
Excelchat Expert 29/06/2018 - 03:03
it looks, we need to revised all the formula if all the value would be negative
User 29/06/2018 - 03:04
but in general
User 29/06/2018 - 03:04
it should be the same formula correct?
User 29/06/2018 - 03:04
but now it just needs to pul
User 29/06/2018 - 03:04
the next smallest value?
Excelchat Expert 29/06/2018 - 03:04
yes, unfortunately vlookup formula doesn't work like that if all values are negative
User 29/06/2018 - 03:05
oh really?
User 29/06/2018 - 03:05
i didnt know vlookup had such a flaw
Excelchat Expert 29/06/2018 - 03:05
yes, you may check the formula i type in E6
Excelchat Expert 29/06/2018 - 03:06
instead of -3, it shows as -200000000
User 29/06/2018 - 03:06
yeah
User 29/06/2018 - 03:06
interesting
Excelchat Expert 29/06/2018 - 03:06
so if all values would be negative, we need to create another formula again
Excelchat Expert 29/06/2018 - 03:06
that will works for negative
User 29/06/2018 - 03:07
ahh okay, its fine, i will tkae it from this
User 29/06/2018 - 03:07
this formula alone was a good start for me
Excelchat Expert 29/06/2018 - 03:07
great :)
Excelchat Expert 29/06/2018 - 03:07
i'm glad I've helped you :)
User 29/06/2018 - 03:07
thanks!
Excelchat Expert 29/06/2018 - 03:07
Apart from this, is there anything else you want to know on your problem?
User 29/06/2018 - 03:07
no
User 29/06/2018 - 03:07
that was basically it
User 29/06/2018 - 03:07
thank you!
Excelchat Expert 29/06/2018 - 03:08
good :)
Excelchat Expert 29/06/2018 - 03:08
welcome :)
Excelchat Expert 29/06/2018 - 03:08
Thanks for using Got It Pro. Please give your kind feedback for our service. You may click the End session to close our session properly and provide your kind feedback Have a good day ahead ^_^

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc