Kymm

Posts: n/a

How do you perform a two-column lookup?

I am trying to do a lookup using 2 columns. Example would be

SKU Warehouse Qty
13 CA 15
14 CA 30
15 CA 18
13 HN 10
14 HN 5

I want to be able to pull the qty for any given SKU Warehouse combination.

Any help would be great.

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
2 Column Data lookup	Hari	Excel Discussion (Misc queries)	2	June 15th 05 07:54 AM
Column Lookup	N Harkawat	Excel Discussion (Misc queries)	1	June 14th 05 03:39 PM
Lookup last entry in column	Angelo Sartore	Excel Discussion (Misc queries)	3	March 16th 05 11:41 AM
Lookup then Match and insert value from next column	Tenacity	Excel Worksheet Functions	3	March 4th 05 02:49 AM
How to lookup data in a row and column	Confused	Excel Discussion (Misc queries)	5	January 10th 05 08:20 PM

All times are GMT +1. The time now is 09:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us