Jenniferpod Jenniferpod is offline

Junior Member

Posts: 8

Find function

I have two worksheets. In cell a2 of worksheet 1 I want to find if the value of worksheet 1 cell b2 exists within worksheet 2 column b. If found, I want to return the value of worksheet 2 column a (same row that the the original lookup was found). If not found, I want to leave the cell blank.

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
If find function to not find anything	Carlos	Excel Programming	4	February 14th 08 09:25 AM
Help with Find function	Extropian	Excel Programming	3	May 30th 07 04:14 PM
Find function	Kris	Excel Programming	2	September 27th 06 10:00 AM
Find function	Jahunga	Excel Worksheet Functions	2	November 22nd 04 03:38 PM
backwards find function to find character in a string of text	Ashleigh K.	Excel Programming	1	January 14th 04 04:36 PM

All times are GMT +1. The time now is 08:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us