Posted to microsoft.public.excel.misc

external usenet poster

Posts: 28

Lookup data in 2 columns

Example:

C1 C2 C3
R1 Apple Fuji 10

I want to create a lookup that will return the value 10 if C1=Apple AND
C2=Fuji.
Can someone help? Thank you.

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
sorting 2 colums of numbers and incremening them down	blk&wht	Excel Discussion (Misc queries)	10	October 9th 06 10:12 PM
summing columns if there is data	Dave	Excel Worksheet Functions	2	June 22nd 06 08:04 PM
Data in narrow columns truncated when saving as DBF	Ben Amada	Excel Discussion (Misc queries)	2	October 11th 05 11:23 PM
Sort pages?	David	Excel Discussion (Misc queries)	15	May 13th 05 11:33 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM

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

About Us

"It's about Microsoft Excel"