Excel Formula needed Closed

Question

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.

venkat1926 · Answer

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

guitarthrower · Answer

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.

Excel Formula needed

2 responses

Similar discussions

Subscribe To Our Newsletter!