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 |
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 |
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 |
All times are GMT +1. The time now is 09:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com