Lookup

texasalynn · Jan 27th 2003

This seems like a simple vlookup but it's not. I need a way to take information from a separate workbook where it needs to find the intersection of the column and row.

So I need to lookup from the current workbook cell A3=1-21-2003 and cell C3=Tray2 so the result will return "1" from the separate workbook.
Here is an example of the pivot table that I need to lookup to find the intersection

A B C D
Date: Tray1 Tray2 Tray3
1-21-2003 1 1 1
1-22-2003 2 1 2
1-23-2003 3 2 3

HELP me please!

Thanks,
texasalynn

bumble · Jan 27th 2003

If you add a row under your date: Tray column and put in the column numbers eg.
Tray1 Tray2 Tray3
2 3 4

You could get away with the following formula:-
=VLOOKUP(A3,Sheet2!$A$1:$D$5,HLOOKUP(C3,Sheet2!$B$1:$D$2,2,FALSE))

Cheers,

AJW · Jan 28th 2003

Try the lookup's in the attached from Excel Logic web site.

yjoshi · Mar 11th 2003

Hi AJW,

This excel sheet is reallv too good.

Which is the site you are mentioning here?

Looks to be interesting.

Richie(UK) · Mar 11th 2003

Hi yjoshi

The site mentioned is here:

http://www.xl-logic.com/menu.html

(Pretty good isn't it?)

yjoshi · Mar 11th 2003

Thanx a lot.

Share