Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / July 2006

Tip: Looking for answers? Try searching our database.

Multiple Lookups

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rossitl - 13 Jul 2006 12:26 GMT
Hope you guys can help.  I have a pretty Basic knowledge of Excel and just
get by.  I need to return a cell from a table where two other columns are the
same. For example

My Table

A  B  C
1  2  X
2  2  Y
3  2  Z

My Workbook

A  B  C
3  2
2  2

So if my workbook in columns A and B is the same as my table columns A and B
output column C into my workbook

I have a knowledge of Vlookup and can easily enough output looking up one
column but this is the first time I have needed to lok over two columns

Hope I have explained myself ok.
Franz Verga - 13 Jul 2006 13:40 GMT
> Hope you guys can help.  I have a pretty Basic knowledge of Excel and
> just get by.  I need to return a cell from a table where two other
[quoted text clipped - 21 lines]
>
> Hope I have explained myself ok.

I think your problem is similar to that in this link:

http://groups.google.it/group/microsoft.public.excel.programming/browse_frm/thre
ad/b5b76a9389d1c5d9/3e01670a40488147?hl=it#3e01670a40488147


Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.