lookup value in column

Posted to microsoft.public.excel.programming

raraschek

external usenet poster

Posts: 12

lookup value in column

thanks for help:
do you have any idea, how to find out, if a value (B5) IS in a range
(A2:A4000)?
I canÂ´t sort these values, so I thought I canÂ´t use any search function, and
donÂ´t have idea how to compile this code. thanks

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 looks to the prior column if zero appears in the lookup col	kenbquik	Excel Discussion (Misc queries)	2	March 12th 09 03:41 AM
LookUp Function with Two Column Search Returning One Column Value	insitedge	Excel Worksheet Functions	8	March 3rd 08 05:59 AM
macro column lookup enter data in another column same row	mikeolson	Excel Programming	12	November 19th 07 05:29 PM
lookup text in one column, count in another column	dmshurley	Excel Worksheet Functions	1	August 17th 07 11:32 PM
Calculating totals in a column based on a lookup in another column	Michael Wright via OfficeKB.com	Excel Worksheet Functions	1	April 15th 05 09:52 AM

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

Menu

About Us