Posted to microsoft.public.excel.worksheet.functions

ferosha42

external usenet poster

Posts: 3

help with search/lookup

I have 2 sheets.

Sheet 1 has just a few vendor numbers listed in column A.

Sheet 2 has ALL vendor numbers (about 30,000) in Column A and the vendor
name in Column B.

I want to do a formula in Sheet 1(cell B1) that would search sheet 2, and
match the vendor number with its corresponding name and show that name in B1.

anyone know how to do that???

Please help! 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
Search/Lookup and Place	bassmanfranc	Excel Worksheet Functions	2	March 21st 07 01:23 PM
Search and lookup	KJW31	Excel Worksheet Functions	1	September 14th 06 09:47 PM
LOOKUP w/ multiple search columns?	Fotop	Excel Discussion (Misc queries)	1	March 24th 06 12:10 PM
search all tabs for tab name specified & lookup reference?	BMW	Excel Worksheet Functions	5	November 4th 05 04:16 PM
Search/lookup/cell reference	daetar	Excel Worksheet Functions	1	June 21st 05 06:47 PM

All times are GMT +1. The time now is 02:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us