# EXCEL ARRAYS & IF STATEMENTS

G

#### Guest

Hello,

=IF(COLUMNS(\$B1:B1)<=COUNTIF(INDEX(Tbl,0,1),\$A1),
OFFSET(Tbl,SMALL(IF(INDEX(Tbl,0,1)=\$A1,ROW(Tbl)-CELL("Row",Tbl)),
COLUMNS(\$B1:B1)),1,1,1),"")

PROBLEM# 2

This is a great formula! I just forgot, i need one more IF statement
nested, how would i add another IF statement to check for anothe value so
this is the table:

PART# PO# Store#
A1: 021-310L B1: 107893 C1: 001
A2: 021-310L B2: 108983 C2: 002
A3: 021-310L B3: 109983 C30

So now I need to have these results on the next page:

PART# STR# PO# PO#
A1: 021-310L B1: 001 C1: 107893 D1: 109983
A2: 021-310L B1: 002 C2: 108983 D2:

G

#### Guest

problem solved, thanks!

Dan said:
Hello,

=IF(COLUMNS(\$B1:B1)<=COUNTIF(INDEX(Tbl,0,1),\$A1),
OFFSET(Tbl,SMALL(IF(INDEX(Tbl,0,1)=\$A1,ROW(Tbl)-CELL("Row",Tbl)),
COLUMNS(\$B1:B1)),1,1,1),"")

PROBLEM# 2

This is a great formula! I just forgot, i need one more IF statement
nested, how would i add another IF statement to check for anothe value so
this is the table:

PART# PO# Store#
A1: 021-310L B1: 107893 C1: 001
A2: 021-310L B2: 108983 C2: 002
A3: 021-310L B3: 109983 C30

So now I need to have these results on the next page:

PART# STR# PO# PO#
A1: 021-310L B1: 001 C1: 107893 D1: 109983
A2: 021-310L B1: 002 C2: 108983 D2: