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
|