Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neil
 
Posts: n/a
Default vlookup over multiple worksheets

Hi All,

How best can I do a vlookup over multiple worksheets without resorting to a
macro ??

I have 5 sheets and the vlookup value is in one of them (not sure which one)
so I'd like
the worksheet function to cycle through them to find the lookup reference
otherwise
through out an error message.

I have tried 'if(iserror(vlookup......' looping from sheet to sheet but this
is painstaking and
not getting me there.

Thanks for the assistance.

Neil


  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
is the return value a numeric value?

"Neil" wrote:

Hi All,

How best can I do a vlookup over multiple worksheets without resorting to a
macro ??

I have 5 sheets and the vlookup value is in one of them (not sure which one)
so I'd like
the worksheet function to cycle through them to find the lookup reference
otherwise
through out an error message.

I have tried 'if(iserror(vlookup......' looping from sheet to sheet but this
is painstaking and
not getting me there.

Thanks for the assistance.

Neil



  #3   Report Post  
Neil
 
Posts: n/a
Default

Thanks Frank,

The return values are numeric....

Regards,

Neil.


"Frank Kabel" wrote in message
...
Hi
is the return value a numeric value?

"Neil" wrote:

Hi All,

How best can I do a vlookup over multiple worksheets without resorting to
a
macro ??

I have 5 sheets and the vlookup value is in one of them (not sure which
one)
so I'd like
the worksheet function to cycle through them to find the lookup reference
otherwise
through out an error message.

I have tried 'if(iserror(vlookup......' looping from sheet to sheet but
this
is painstaking and
not getting me there.

Thanks for the assistance.

Neil





  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
then you may provide some more details:
- how are your sheets exactly named
- which column to search and which to return
- can the resulting value only appear once (or could you have multiple
matches)

--
Regards
Frank Kabel
Frankfurt, Germany

Neil wrote:
Thanks Frank,

The return values are numeric....

Regards,

Neil.


"Frank Kabel" wrote in message
...
Hi
is the return value a numeric value?

"Neil" wrote:

Hi All,

How best can I do a vlookup over multiple worksheets without
resorting to a
macro ??

I have 5 sheets and the vlookup value is in one of them (not sure
which one)
so I'd like
the worksheet function to cycle through them to find the lookup
reference otherwise
through out an error message.

I have tried 'if(iserror(vlookup......' looping from sheet to sheet
but this
is painstaking and
not getting me there.

Thanks for the assistance.

Neil



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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 06:33 PM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 3rd 04 12:23 AM
copy pivot table to multiple worksheets Todd Excel Worksheet Functions 2 November 19th 04 04:16 AM
Multiple Vlookup? changeable Excel Worksheet Functions 0 November 9th 04 12:52 PM


All times are GMT +1. The time now is 06:00 PM.

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

About Us

"It's about Microsoft Excel"