complex conditional formulas in excel using "IF"
i am trying to create a column in an excel sheet using multiple IF statements
IF the value in sheet5 column B = X, then go to sheet1 IF the value in sheet5 column B = N, then go to sheet2 etc Then Find the value in sheetX columnA that equals Sheet5 columnA corresponding to row of formula Retrieve the value in sheetX column C and enter it into this cell Then i want to copy the formula syntax for the enite column in sheet5 |
sounds like if and vlookup will do what you want but you are limited by the
number of ifs eg=if(b5=x,vlookup(A5,Sheet1!A1:C100,3,false),if(B 5=N,vlookup(A5,Sheet2!A1:C100,3,false),"not x or n")) -- paul remove nospam for email addy! "jdmas" wrote: i am trying to create a column in an excel sheet using multiple IF statements IF the value in sheet5 column B = X, then go to sheet1 IF the value in sheet5 column B = N, then go to sheet2 etc Then Find the value in sheetX columnA that equals Sheet5 columnA corresponding to row of formula Retrieve the value in sheetX column C and enter it into this cell Then i want to copy the formula syntax for the enite column in sheet5 |
Hi!
If you created named ranges for "X" and "N", then something like this: =VLOOKUP(A5,INDIRECT(B5),3,0) Biff "paul" wrote in message ... sounds like if and vlookup will do what you want but you are limited by the number of ifs eg=if(b5=x,vlookup(A5,Sheet1!A1:C100,3,false),if(B 5=N,vlookup(A5,Sheet2!A1:C100,3,false),"not x or n")) -- paul remove nospam for email addy! "jdmas" wrote: i am trying to create a column in an excel sheet using multiple IF statements IF the value in sheet5 column B = X, then go to sheet1 IF the value in sheet5 column B = N, then go to sheet2 etc Then Find the value in sheetX columnA that equals Sheet5 columnA corresponding to row of formula Retrieve the value in sheetX column C and enter it into this cell Then i want to copy the formula syntax for the enite column in sheet5 |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com