LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Returning a value from the cell next to my match

I'm trying to create a formula that will search a column and if a match is
found return the data in the cell next to my original number. In this
instance, I have a column of numbers that represents a company. On another
worksheet, I have a column of all of the company numbers and the next column
is the company name. I want to search the list of company numbers and return
the company name in the other worksheet.
--
Ron
 
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
Match returning #N/A Frank Pytel Excel Worksheet Functions 7 November 4th 08 07:14 PM
vlookup not returning a match even when there is one karen Excel Worksheet Functions 6 July 14th 08 02:09 PM
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 12:50 AM
Match/Index Returning #N/A Will Excel Worksheet Functions 6 April 15th 06 05:10 AM
VLOOKUP returning LAST match Brian Ferris Excel Discussion (Misc queries) 1 April 4th 05 02:00 PM


All times are GMT +1. The time now is 06:04 AM.

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"