#1   Report Post  
Old November 1st 04, 12:49 PM
Amit
 
Posts: n/a
Default 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))

  #2   Report Post  
Old November 1st 04, 01:38 PM
duane
 
Posts: n/a
Default


=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

  #3   Report Post  
Old November 1st 04, 04:52 PM
Aladin Akyurek
 
Posts: n/a
Default


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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup finds a blank, but returns a zero - HELP! flummoxed Excel Discussion (Misc queries) 6 January 18th 05 03:15 PM
Vlookup Syntax Error YV New Users to Excel 9 December 23rd 04 05:28 PM
Vlookup Question Jeff Excel Discussion (Misc queries) 2 December 2nd 04 02:40 PM
Need help with modifying VLookUp Tom Excel Discussion (Misc queries) 4 December 2nd 04 12:44 AM
vlookup and IF function cambridge Excel Worksheet Functions 5 October 28th 04 08:29 PM


All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017