Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help need for formula
I HAVE TWO COLOUMS OF DATA in A column i have sl numbers in B column i will enter the sys number if i enter 1 - 100 in column B i want the word "Dell"to be appear in colum C If I enter 101 - 200 in column B i want the word "HP"to appear in column C eg: A B C 1 97 Dell 2 98 Dell 3 99 Dell 4 101 HP 5 102 Hp Help needed -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99841 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
help need for formula
=LOOKUP(B1,{1,101,201},{"Dell","HP"})
"Sathisc" wrote: I HAVE TWO COLOUMS OF DATA in A column i have sl numbers in B column i will enter the sys number if i enter 1 - 100 in column B i want the word "Dell"to be appear in colum C If I enter 101 - 200 in column B i want the word "HP"to appear in column C eg: A B C 1 97 Dell 2 98 Dell 3 99 Dell 4 101 HP 5 102 Hp Help needed -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99841 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|