I have attached a sample of what formula i am after.
Basically i have a row of values, that i need compared to an entered value.
The result required is to find from the row of data, the next > value to the entered value, and return the cell value in row 3(offset1 row).
Hope i have explained that ledgebly enough to comprehend.
Your C2 cell formula is creating a Circular Reference, so first correct the C2 cell formula and then we will go for the rest
Your C2 Cell Formula
=$C2-(COLUMNS(B$2:$C$2)/11)*($C$2-$N$2)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I have fixed up the table data.
I thought a HLookup would work, but it errors?
The error is a ' Value not available' error.
Do i need to add a rounding up/down step for the looked up value or something?
But my undertsanding is that the TRUE looks for a cloise match.
bump for a reply .....
Self solved with: =OFFSET(INDEX(B2:M2,MATCH(D7,B2:M2,-1)),1,0)
Try this…
In D7 Cell
=INDEX(C3:L3,,MATCH(SMALL(C2:L2,COUNTIF(C2:L2,"<="&D7)),C2:L2,0))
Or
=INDEX(C3:L3,,MATCH(SMALL(C2:L2,COUNTIF(C2:L2,"<="&D7)+1),C2:L2,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks