vlookup on 3 different tables - please HELP
Hi
I have a value that can be found in coulmn A of 3 different tables, i would like to perform the lookup on the 3 tables. can it be done without unifying the tables? thanks |
vlookup on 3 different tables - please HELP
can or may if you mean it might be in table 1 and stop use something like =VLOOKUP(C1,IF(ISNA(VLOOKUP(C1,tab1,2,0)),tab2,tab 1),2,0) Don Guillett SalesAid Software "Nir" wrote in message ... Hi I have a value that can be found in coulmn A of 3 different tables, i would like to perform the lookup on the 3 tables. can it be done without unifying the tables? thanks |
vlookup on 3 different tables - please HELP
=IF(ISNA(VLOOKUP(value,table1,2,FALSE)),IF(ISNA(VL OOKUP(value,table2,2,FALSE
)), IF(ISNA(VLOOKUP(value,table3,2,FALSE)),"Not found", VLOOKUP(value,table3,2,FALSE)),VLOOKUP(value,table 2,2,FALSE)),VLOOKUP(value, table1,2,FALSE)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Nir" wrote in message ... Hi I have a value that can be found in coulmn A of 3 different tables, i would like to perform the lookup on the 3 tables. can it be done without unifying the tables? thanks |
vlookup on 3 different tables - please HELP
If the free add-in Morefunc.xll is downloaded and installed, then
something like the following formula can be used... =VLOOKUP(B2,THREED('Sheet1:Sheet3'!$A$2:$B$100),2, 0) Alternatively, let A2:A4 contain the sheet names, then try the following formula which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER... =VLOOKUP(B2,INDIRECT("'"&INDEX($A$2:$A$4,MATCH(TRU E,COUNTIF(INDIRECT("'"& $A$2:$A$4&"'!A2:A100"),B2)0,0))&"'!A2:B100"),2,0) The add-in can be downloaded here... http://xcell05.free.fr/ Hope this helps! In article , Nir wrote: Hi I have a value that can be found in coulmn A of 3 different tables, i would like to perform the lookup on the 3 tables. can it be done without unifying the tables? thanks |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com