| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup across multiple sheets & return sum of cells | Excel Worksheet Functions | |||
| How do I merge two seperate sheets together? | Excel Discussion (Misc queries) | |||
| array range in seperate sheets | Excel Worksheet Functions | |||
| Query to Return Value from Seperate Worksheet | Excel Discussion (Misc queries) | |||
| How can I look up two seperate values/cells and return the value . | Excel Worksheet Functions | |||
Linear Mode
