Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA
I have the below A B C D E 1 JAN FEB MAR APR 2 500 300 200 100 3 4 5 I WANT FORMULA TO WRITE IN A5 THAT IF A5= JAN IT SHOULD TAKE B2 AND IF A5=FEB, IT SHOULD TAKE C2, IF A5=MAR IT SHOULD TAKE D2 AND IF A5=APR, IT SHOULD TAKE E2 LIKE THAT. CAN ANY ONE HELP ME PLEASE THANKS -- srinivas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA
Try
=LOOKUP(A5,B1:E1,B2:E2) Mike "Srinivas" wrote: I have the below A B C D E 1 JAN FEB MAR APR 2 500 300 200 100 3 4 5 I WANT FORMULA TO WRITE IN A5 THAT IF A5= JAN IT SHOULD TAKE B2 AND IF A5=FEB, IT SHOULD TAKE C2, IF A5=MAR IT SHOULD TAKE D2 AND IF A5=APR, IT SHOULD TAKE E2 LIKE THAT. CAN ANY ONE HELP ME PLEASE THANKS -- srinivas |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA
THANKS
-- srinivas "Mike H" wrote: Try =LOOKUP(A5,B1:E1,B2:E2) Mike "Srinivas" wrote: I have the below A B C D E 1 JAN FEB MAR APR 2 500 300 200 100 3 4 5 I WANT FORMULA TO WRITE IN A5 THAT IF A5= JAN IT SHOULD TAKE B2 AND IF A5=FEB, IT SHOULD TAKE C2, IF A5=MAR IT SHOULD TAKE D2 AND IF A5=APR, IT SHOULD TAKE E2 LIKE THAT. CAN ANY ONE HELP ME PLEASE THANKS -- srinivas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|