multiple sheet lookup or match

V

Vegas Sara

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.
 
J

Jacob Skaria

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 erro
=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
 
V

Vegas Sara

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

Vegas Sara

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
 
J

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Exact Match using INDEX, MATCH 1
Lookups??? 2
INDEX MATCH SMALL 12
With F1 value, look at A, if match or partial match return B 5
How can I lookup when match has more than one value? 2
lookup second / last match with two conditions 1
If, Lookup, Match or a combination of all 3
Sum with multiple criteria 6

Top