Ste1978 Wrote:
Thanks very much. I have nearly completed my spreadsheet due to your
help. The only point im now stuck on is as follows:-
This is my setup at the moment
Sheet1(Codes)
A B
1 FLC(A) PART NUMBER
2 0.11 3RV1011-0AA10
3 0.12 3RV1011-0AA10
4 0.13 3RV1011-0AA10
5 0.14 3RV1011-0BA10
6 0.15 3RV1011-0BA10
7 0.16 3RV1011-0BA10
Sheet2(3RV Breakers)
A B
1 =VLOOKUP(B5,Codes!$A$2:$B$91,2,FALSE)
so if I enter '0.12' in A1 then I get a return of '3RV1011-0AA10' B1
which is what I want. However, on sheet1 can I enter a range i.e. 0.11
to 013 which will still give me 3RV1011-0AA10? instead of listing the
ranges individually, for example I have a range of 0.7 to 1.0 which all
equal 3RV1011-0JA10 but I dont want to list on sheet1 an entry of 0.7,
0.71, 0.72 etc..
Thanks again for the already sterling advice.
Use TRUE instead of FALSE.
Suppose your data is
0.7 3RVXXXXXX
1.0 3RVYYYYYY
1.4 3RVZZZZZZ etc
2.0 3RVQQQQQ
then using TRUE will return 3RVXXXXXX for any value between .7 and
less than 1.0, return 3RVYYYYYYY for value between 1.0 and less than
1.4 and return 3RVZZZZZZZ for all values between 1.4 and less than 2.0
A V Veerkar
--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile:
http://www.excelforum.com/member.php...o&userid=30338
View this thread:
http://www.excelforum.com/showthread...hreadid=521647