Multiple Lookups

  • Thread starter Thread starter rossitl
  • Start date Start date
R

rossitl

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.
 
rossitl said:
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.
Click to expand...


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

http://groups.google.it/group/micro...1c5d9/3e01670a40488147?hl=it#3e01670a40488147

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Back
Top