Hi guys
I will try and explain this the best I can... in fact I am not even sure if an if statement is the best function to use.
Basically I have got a matrix of "bandings".
I want to test a cell, to say " if the value in the cell is between two seperate numbers, put a value in the cell.
I've attached an example with further explination.
Would really appreciate some input on this - i've racked my brains and i'm stumped.
Thanks in advance
Last edited by The Boosh!; 07-04-2011 at 10:43 AM.
Acoording to my math.. 1.7 is not between 1.75 and 2.25
try this:
=VLOOKUP(B2, $G$2:$I$12, 3, TRUE)
Never use Merged Cells in Excel
Wow, thanks all for the speedy responses guys :D
All the functions mentioned worked perfectly, thanks again!
[QUOTE=zbor;2556845]Acoording to my math.. 1.7 is not between 1.75 and 2.25
[QUOTE]
Sorry, slow Day lol! :D
Hi
in B2 tryand pull down as needed
=LOOKUP(B2,$G$2:$G$12,$I$2:$I$12)
Hi,
In C2, and copied down,
INDEX($I$2:$I$12,MATCH(B2,$G$2:$G$12,1))
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks