Hi I have a question that might be simple, I need cell B1 to give me an factor based on where the number in A1 is in a range. My range looks something like this...
Start Stop Factor
1000 2000 1.04
2000 3000 1.08
3000 4000 1.12
4000 5000 1.16
5000 6000 1.2
7000 8000 1.24
So if A1 was 2313 B1 would return 1.08. Is this something simple to do?
Does this do what you want?
Just realised that sheet one is something else I was trying. Yours is sheet 2.
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
WOW......WOWOriginally Posted by Russell Dawson
You just showed me something i did not know about VLOOKUPs, that is very cool and should work, thanks.
Glad to be able to help. Please mark the thread as solved and help my reputation by clicking the star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks