Prev Previous Post   Next Post Next
  #1   Report Post  
Sonya
 
Posts: n/a
Default FIND function?

I need to search a column for text and return the value from the column
beside it.

so... where "d1" occurs in b4:b60, I need it to return the value in cloumn
a. this information will be pulled from sheet 3 of a worksheet and posted in
sheet 1.

so if in sheet 3 - "d1" appears in b16 then I need it to return the value in
a16 in sheet 1 in a designated cell. This is all text formatting.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Function to find closest to 0 (including neg #'s) in cloumn Dante Excel Discussion (Misc queries) 9 October 13th 05 05:39 AM
How do I create an equivalent VLOOKUP function using FIND? dan Excel Worksheet Functions 8 August 17th 05 04:43 PM
Can VLookup function find and list multiple records? Rich - SG Excel Worksheet Functions 11 July 5th 05 07:44 PM
Help with the FIND function Ranger Excel Worksheet Functions 1 February 25th 05 03:24 PM
how can I use a function to find out if an individual cell is par. nick.pattison Excel Worksheet Functions 3 January 13th 05 06:45 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"