Menu

Search range of cells, find a value, output adjoining cell. How?

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.worksheet.functions

nyys

Posts: n/a

Default

Search range of cells, find a value, output adjoining cell. Ho

I found what I was doing wrong. Thanks!

"nyys" wrote:

I can't seem to get it to work. First I've ever heard of the VLOOKUP
function. Could you provide an example?

thanks,
-paul

"Gary L Brown" wrote:

If Col A is Player and Col B is Position, put a formula =A1 in Col C so that
Col A is duplicated. Then use a vlookup in sheet 2
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

"nyys" wrote:

Here's what I'm trying to do.

I have several columns of data. I would like to search one of those columns
(a range) for a specific value. If that value is found I want to output the
value of the cell that is to the left of the cell where the search value was
found, on another sheet.

On Sheet 1
Column 1 is a list of 26 baseball players. Column 2 is their position.

I want to search thru column 2 for a specific position, lets say "c" for
catcher. If "c" is found I want the cell to the left of the "c" (the players
name) to out put on Sheet 2.

On Sheet 2
Is a baseball diamond, and I want the name to appear in the place on the
diamond I choose.

So basically I need a formula to place in a particular cell on Sheet 2 that
looks thru the data on Sheet 1 in the way explained above.

Thanks,
-paul

Reply With Quote

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
need to Copy or Move to active cell from specified range	kaream	Excel Discussion (Misc queries)	2	December 14th 05 08:12 AM
Find last occurance of text in range	farutherford	Excel Worksheet Functions	5	August 30th 05 02:00 AM
copying cell names	Al	Excel Discussion (Misc queries)	12	August 11th 05 03:01 PM
Copy cells into range of cells until cell change	mdeanda	Excel Worksheet Functions	1	April 22nd 05 08:41 PM
find a cells from a range of cell	kelvintaycc	Excel Worksheet Functions	2	April 2nd 05 07:20 PM

All times are GMT +1. The time now is 05:52 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement