If Question
I am trying to get information based on a name. I tried the following
formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
Try putting double quotes around the names:
=IF(B3="Brian",...... -- Biff Microsoft Excel MVP "Johnnie" wrote in message ... I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
Try putting the names in quotes, "Brian", "Cindy", "David". HTH Otto
"Johnnie" wrote in message ... I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
If you have only three names then you are on the right track..you need to put
quotes around names (text strings) Try =IF(B3="Brian",Sheet2!E2,if(B3="Cindy",Sheet2!E3,i f(B3="David",Sheet2!E4,""))) "Johnnie" wrote: I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
Hi,
very close, instead use =IF(B3="Brian",Sheet2!E2,if(B3="Cindy",Sheet2!E3,i f(B3="David",Sheet2!E4,""))) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Johnnie" wrote: I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
Shane,
Thanks, it works great. Two questions: 1. Do the names require the quotes because I am pulling them from a list and 2. How long can the string be? I have 35 names to incorporate into the formula. Johnnie "Shane Devenshire" wrote: Hi, very close, instead use =IF(B3="Brian",Sheet2!E2,if(B3="Cindy",Sheet2!E3,i f(B3="David",Sheet2!E4,""))) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Johnnie" wrote: I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
If Question
The names need to be in quotes because that is how Excel denotes a text
string. If rather than "How long can the string be?" you intended to ask how many IF statements can be nested together in this way, the answer is only 7 for Excel 2003. If you've got more than that the recommendation is usually to use the VLOOKUP function instead of nested IFs. Excel help will give you examples as to how to use VLOOKUP, and there are plenty of recommendations in the archive of this newsgroup. -- David Biddulph "Johnnie" wrote in message ... Shane, Thanks, it works great. Two questions: 1. Do the names require the quotes because I am pulling them from a list and 2. How long can the string be? I have 35 names to incorporate into the formula. Johnnie "Shane Devenshire" wrote: Hi, very close, instead use =IF(B3="Brian",Sheet2!E2,if(B3="Cindy",Sheet2!E3,i f(B3="David",Sheet2!E4,""))) -- If this helps, please click the Yes button Cheers, Shane Devenshire "Johnnie" wrote: I am trying to get information based on a name. I tried the following formula, but can not get it to work. Please help. Thanks. Johnnie In cell B7 I have the following: =IF(B3=Brian,Sheet2!E2,if(B3=Cindy,Sheet2!E3,if(B3 =David,Sheet2!E4,"") Note: Cell B3 is a list. |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com