Nested Statements

  • Thread starter Thread starter Steve_Pete
  • Start date Start date
S

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
 
Hi Steve
maybe you could explain with some more detail what are you trying to
achieve?. Maybe an example
 
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
 
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))
 
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
 
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
 
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
 
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
 
Back
Top