View Single Post
  #5   Report Post  
Krista F
 
Posts: n/a
Default

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?