Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 22

Lookup help needed

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€ has €œX€ in name row?
Thank you
Guntars

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
Lookup help needed	Guntars	Excel Worksheet Functions	2	May 23rd 09 05:39 PM
Lookup help needed	Guntars	Excel Worksheet Functions	1	May 22nd 09 07:08 AM
Lookup value needed	Deepak	Excel Discussion (Misc queries)	3	July 6th 08 03:30 AM
Lookup help needed	atran	Excel Worksheet Functions	1	June 22nd 05 09:24 PM
Vertical lookup help needed	Have three columns R,S,T	Excel Worksheet Functions	1	December 11th 04 11:11 AM

All times are GMT +1. The time now is 10:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us