Expanded V-lookup two coumns from seperate sheets return other col
Heya,
I want to get a result if a value in workbook A searches through workbook B and match in text. The text should not be exact matches as there may be exclamation marks and the sort. if they do match i would like the return value to be a different column. if they dont match the return should be "N/F" (not found) something similar to this, if A1(workbook A)= A(the searched row in workbook B) **a column in workbook B is searched and if it equals A1, then Return B(the searched row in workbook B) **so if it is found it will return a value in a different column, say B (in the same) else returns, "Not found" im ok with the basic funcitons but this one blew me away. will really appreciate any help. Cheers thanks very much, Reza |
Expanded V-lookup two coumns from seperate sheets return other col
"Reza" wrote: Heya, I want to get a result if a value in workbook A searches through workbook B and match in text. The text should not be exact matches as there may be exclamation marks and the sort. if they do match i would like the return value to be a different column. if they dont match the return should be "N/F" (not found) something similar to this, if A1(workbook A)= A(the searched row in workbook B) **a column in workbook B is searched and if it equals A1, then Return B(the searched row in workbook B) **so if it is found it will return a value in a different column, say B (in the same) else returns, "Not found" im ok with the basic funcitons but this one blew me away. will really appreciate any help. Cheers thanks very much, Reza try this - =IF(VLOOKUP(A16,[Book2]Sheet1!B4:D11,2,FALSE)=A16,VLOOKUP(A16,[Book2]Sheet1!B4:D11,3,FALSE),"n/f") |
Expanded V-lookup two coumns from seperate sheets return other
Hi Abbey,
its giving me a "nf" but the value is there this is what the first row should be like, =IF(VLOOKUP(A8,'[Whole building _ Info for Zonal EDB Environmental Review.xls]Sheet1'!$A$2:$A$1616,1)=A8,VLOOKUP(A8,'[Whole building _ Info for Zonal EDB Environmental Review.xls]Sheet1'!$A$2:$A$1616,3,),"n/f") The text may not be exact. any thoughts? "Abbey" wrote: "Reza" wrote: Heya, I want to get a result if a value in workbook A searches through workbook B and match in text. The text should not be exact matches as there may be exclamation marks and the sort. if they do match i would like the return value to be a different column. if they dont match the return should be "N/F" (not found) something similar to this, if A1(workbook A)= A(the searched row in workbook B) **a column in workbook B is searched and if it equals A1, then Return B(the searched row in workbook B) **so if it is found it will return a value in a different column, say B (in the same) else returns, "Not found" im ok with the basic funcitons but this one blew me away. will really appreciate any help. Cheers thanks very much, Reza try this - =IF(VLOOKUP(A16,[Book2]Sheet1!B4:D11,2,FALSE)=A16,VLOOKUP(A16,[Book2]Sheet1!B4:D11,3,FALSE),"n/f") |
Expanded V-lookup two coumns from seperate sheets return other
Reza, after the lookup range i.e. 1 & 3 (in your formular) include the word
false (see my own formular below for guidance). This should sort it. "Reza" wrote: Hi Abbey, its giving me a "nf" but the value is there this is what the first row should be like, =IF(VLOOKUP(A8,'[Whole building _ Info for Zonal EDB Environmental Review.xls]Sheet1'!$A$2:$A$1616,1)=A8,VLOOKUP(A8,'[Whole building _ Info for Zonal EDB Environmental Review.xls]Sheet1'!$A$2:$A$1616,3,),"n/f") The text may not be exact. any thoughts? "Abbey" wrote: "Reza" wrote: Heya, I want to get a result if a value in workbook A searches through workbook B and match in text. The text should not be exact matches as there may be exclamation marks and the sort. if they do match i would like the return value to be a different column. if they dont match the return should be "N/F" (not found) something similar to this, if A1(workbook A)= A(the searched row in workbook B) **a column in workbook B is searched and if it equals A1, then Return B(the searched row in workbook B) **so if it is found it will return a value in a different column, say B (in the same) else returns, "Not found" im ok with the basic funcitons but this one blew me away. will really appreciate any help. Cheers thanks very much, Reza try this - =IF(VLOOKUP(A16,[Book2]Sheet1!B4:D11,2,FALSE)=A16,VLOOKUP(A16,[Book2]Sheet1!B4:D11,3,FALSE),"n/f") |
All times are GMT +1. The time now is 08:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com