multiple sheet lookup or match
 

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.

multiple sheet lookup or match
 

Try the below
=IF(G1<"Resolved",VLOOKUP(A1,Sheet2!A:G,7,0),"")


If a match is not found the below formula returns blank; instead of an error
=IF(G1<"Resolved",IF(ISNA(VLOOKUP(A1,Sheet2!A:G,7 ,0)),"",VLOOKUP(A1,Sheet2!A:G,7,0)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Vegas Sara" wrote:

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.

multiple sheet lookup or match
 

I finally got it to work-thank you so much! can you tell me what the 7 and 0
are? and what ISNA is...

"Jacob Skaria" wrote:

Try the below
=IF(G1<"Resolved",VLOOKUP(A1,Sheet2!A:G,7,0),"")


If a match is not found the below formula returns blank; instead of an error
=IF(G1<"Resolved",IF(ISNA(VLOOKUP(A1,Sheet2!A:G,7 ,0)),"",VLOOKUP(A1,Sheet2!A:G,7,0)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Vegas Sara" wrote:

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.

multiple sheet lookup or match
 

From looking at other posts I figured out the 7 corresponds to column g... Is
it possible to add a secondif statement? So it would be if G1<"Resolved" and
C1 = "x". Thank you

"Vegas Sara" wrote:

I finally got it to work-thank you so much! can you tell me what the 7 and 0
are? and what ISNA is...

"Jacob Skaria" wrote:

Try the below
=IF(G1<"Resolved",VLOOKUP(A1,Sheet2!A:G,7,0),"")


If a match is not found the below formula returns blank; instead of an error
=IF(G1<"Resolved",IF(ISNA(VLOOKUP(A1,Sheet2!A:G,7 ,0)),"",VLOOKUP(A1,Sheet2!A:G,7,0)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Vegas Sara" wrote:

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.

multiple sheet lookup or match
 

=IF(AND(G1<"Resolved",C1="x"),VLOOKUP(A1,Sheet2!A :G,7,0),"")

If this post helps click Yes
---------------
Jacob Skaria


"Vegas Sara" wrote:

From looking at other posts I figured out the 7 corresponds to column g... Is
it possible to add a secondif statement? So it would be if G1<"Resolved" and
C1 = "x". Thank you

"Vegas Sara" wrote:

I finally got it to work-thank you so much! can you tell me what the 7 and 0
are? and what ISNA is...

"Jacob Skaria" wrote:

Try the below
=IF(G1<"Resolved",VLOOKUP(A1,Sheet2!A:G,7,0),"")


If a match is not found the below formula returns blank; instead of an error
=IF(G1<"Resolved",IF(ISNA(VLOOKUP(A1,Sheet2!A:G,7 ,0)),"",VLOOKUP(A1,Sheet2!A:G,7,0)),"")

If this post helps click Yes
---------------
Jacob Skaria


"Vegas Sara" wrote:

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.