| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index lookup with multiple match criteria | Excel Worksheet Functions | |||
| Lookup and match then return data from another sheet | Excel Worksheet Functions | |||
| lookup single value in one sheet, return multiple results from theother sheet | Excel Worksheet Functions | |||
| Check if 2 cells match on another sheet then lookup value | Excel Worksheet Functions | |||
| Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
Hybrid Mode
