vlookup
Hello. I am trying to use vlookup to make it look for a value in multiple
sheets in the same workbook. Is that possible? If not what are the other functions that would do that. Please note that this is a heavy workbook about 1200 rows and 6 coloumns. A function should not slow down the speed. Right now i am using vlookup as below to lookup a value in "ACCOUNTS!$A$1:$D$2000" If it cant value in "ACCOUNTS!$A$1:$D$2000" it should not display NA, instead it shoud look for it in "NEW!$A$1:$D$2000" Is this possible? Thanks. =IF(D17=0,"0",VLOOKUP(D17,ACCOUNTS!$A$1:$D$2000,4, FALSE)) |
=IF(D17=0,"0",if(isna(VLOOKUP(D17,ACCOUNTS!$A$1:$D $2000,4,FALSE)), VLOOKUP(D17,NEW!$A$1:$D$2000,4,FALSE)) -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=274138 |
Are ACCOUNTS!$A$1:$D$2000 and NEW!$A$1:$D$2000 sorted in ascending order on their first column? If not, can you set them in ascending order? Amit Wrote: Hello. I am trying to use vlookup to make it look for a value in multiple sheets in the same workbook. Is that possible? If not what are the other functions that would do that. Please note that this is a heavy workbook about 1200 rows and 6 coloumns. A function should not slow down the speed. Right now i am using vlookup as below to lookup a value in "ACCOUNTS!$A$1:$D$2000" If it cant value in "ACCOUNTS!$A$1:$D$2000" it should not display NA, instead it shoud look for it in "NEW!$A$1:$D$2000" Is this possible? Thanks. =IF(D17=0,"0",VLOOKUP(D17,ACCOUNTS!$A$1:$D$2000,4, FALSE)) -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=274138 |
All times are GMT +1. The time now is 04:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com