Nested Statements

[Steve_Pete]

Is there a way to put a nested IF statement inside a
vlookup to expand options of a vlookup? Any help would be
greatly appreciated.

Thanks,
Steve Peterson
Cleveland, Ohio

 

[Frank Kabel]

Hi Steve
maybe you could explain with some more detail what are you trying to
achieve?. Maybe an example

 

[JE McGimpsey]

Yes it's possible.

Which options did you want to expand? What have you tried?

 

[Steve_Pete]

I have a cover sheet that I am trying to populate with
information from another worksheet. Cell A1 in the cover
sheet is also located (for example) in Worksheet 1. But
there are 2 line items of them. There is another cell in
the same row, just located in Worksheet 1, that is not
located in the cover sheet. I would like to be able to
separate the two of them, and bring them into the cover
sheet. Does this make sense?

Thanks,
Steven Peterson

 

[Frank Kabel]

Hi
do you mean that you have for example on your cover sheet to values to
search for. e.g.
A1: condition1
B1: condition 2

And now you want to mathc BOTH of these values with sheet1 (in column
A+B) and return for example the value from column C?. If yes try the
following array formula (entered with cTRL+sHIFT+ENTER):
=INDEX('sheet1'!C1:C100,MATCH(1,('sheet1'!A1:A100=A1)*('sheet1'!B1:B100
=B1),0))

 

[Steve_Pete]

There is just one condition on the cover sheet, but two
conditions on sheet 1. Only one condition matches on both
sheets. I may be able to alter my sheet to bring in your
formula below, but I thought there was a way to use the
vlookup to find condition one (A1,in both cover sheet and
sheet 1), then if condition two (B1,Sheet1)matched what is
in the formula, it would then return a value (C1,Sheet1).

Thanks,
Steve

 

[Frank Kabel]

Hi Steve
I'm still not sure what you're trying to do. Maybe post some example
rows of your three sheets (plain text please - no attachments). And
describe based on these examples what your result should be

 

[Guest]

Hi Frank,

Below is what I am basically looking at, but greatly
simplified. Let me know what you think.

Cover Sheet
Column A Column B
Account Number Dollar Amount
1234
1234
1234

Sheet 1
Column A Column B Column C
Account Number Department Dollar Amount
1234 1A
1234 1B
1234 1C

 

[Frank Kabel]

Hi
so you want to sum column C in your sheet 1 depending on the account
number?. If yes use the following in B2 of your cover sheet:
=SUMIF('sheet1'!$A$1:$A$100,A1,'sheet1'!$C$1:$C$100)

If this is not what you mean please post not only example data BUT also
your expected result