Actuallyif there is an x in B1:B4 I want it to list which rows they are in -
for the grid below querying Column C (poorly labeled B for example) it would
list W1, W2, W4.
I can't even test the formulas now... grr.... I knew vlookup was too good
to be true. Did you end up splitting the book into smaller pieces to solve
the problem or use a workaround statement?
"Fredrik Wahlgren" wrote:
If you want to test if there are x's in B1:B4 you can do this
=IF(B1&B2&B3&B4 = "xxxx", TRUE, FALSE)
What is the signifance of the other range, A1:A4?
CTRL+ALT+F9 will force a recalculation
Maybe you're overloading. I have had lots of problems with VLOOKUP. It seems
to interfere with the calculation engine
/Fredrik
"Krista F" wrote in message
...
Incomplete - sent by mistake...
I'm trying to find a formula that will give me the row header in column a
if
there is an x in the column B1:B4.
A B C D E F
W1 x x x
W2 x x x
W3 x x x x
W4 x
I've tried =IF(B1:B4,"x",A1:A4) Probably not quite right...
My second problem is my workbook is beginning to get screwy. I will go to
enter a formula like the one above and it won't calculate it! I've
checked -
auto calculate is on, I have no other workbooks open, ctrl+~ doesn't do
anything, ctrl+F9 minimizes the workbook, and under tools/options/calcs/
calc
sheet and calc now don't work. In fact, Ctrl N opened a new blank
workbook.
This is a pretty complicated workbook with 8-10 pages of multiple linked
offset and vlookup formulas.... Am I overloading things?
|