Remember Me?

#1
November 1st 04, 01:49 PM
 Amit Posts: n/a
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
November 1st 04, 02:38 PM
 duane Posts: n/a

=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

#3
November 1st 04, 05:52 PM

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
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))

--
------------------------------------------------------------------------

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post flummoxed Excel Discussion (Misc queries) 6 January 18th 05 04:15 PM YV New Users to Excel 9 December 23rd 04 06:28 PM Jeff Excel Discussion (Misc queries) 2 December 2nd 04 03:40 PM Tom Excel Discussion (Misc queries) 4 December 2nd 04 01:44 AM cambridge Excel Worksheet Functions 5 October 28th 04 08:29 PM

All times are GMT +1. The time now is 07:04 PM.