Search : in
By :

Excel Formula needed

Last answer on Oct 13, 2009 7:20:37 pm BST stumpedbyexcel, on Oct 12, 2009 9:45:15 pm BST 
 Report this message to moderators

Hello,
I have a spreadsheet (Sheet1) with 45000 identifiers. I need search another sheet (database) for the identifiers and return a text value from another cell. Was trying to use sumproduct to query the entire sheet for the identifier but cannot seem to get the formula to work in pulling the text value and return that into sheet 1.
In short it is a mapping exercise to search for the identifer in the database and return an additional value associated with it.
Any help woudl be greatly appreciated.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Excel Formula needed » in :
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Excel formula to get the cell with the text Show
Excel Formula Display in Cell (Solved) Show
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
[Excel] – Countif Formula Show[Excel] – Countif Formula Issue Solution Note Issue I have one excel file in that Column "B" has the "pending or Closed" Status and Column "C" has "Severity 1, Severity 2 and Severity 3" I want to count in one cell with "Pending...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

venkat1926, on Oct 13, 2009 3:46:10 am BST

I think you need a macro . try to use "find" function and RECORD macro . the macro can be edited later

   
Reply to venkat1926

2

 guitarthrower, on Oct 13, 2009 7:20:37 pm BST
  • +1

Vlookup should do the trick as long as the text you want to return is in the same row as the identifier, and the identifier is in the leftmost column.

   
Reply to guitarthrower
Ask your question Reply
They need your help