shital shah

Posts: n/a

How to do two way lookup for more than 400 row & Coulmn?

hi to all
how do i match the party name & item to find rate of perticular party for
perticular item.
I want to do two way lookup, but there are not more than 256 column

I have data like
NameofParty in ROWs more than 500 and item1, item2, item3,...........more
than 400 in columns. which way i can find rate of party with item pls. help
me.

****al shah

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to create a lookup table with an added varable?	GIZZMO	Excel Worksheet Functions	3	April 6th 09 10:32 PM
Lookup Problem	StephanieH	Excel Worksheet Functions	1	December 20th 04 06:17 PM
Index table lookup anomaly	Carole O	Excel Worksheet Functions	9	December 9th 04 04:33 PM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us