Excel Formula needed

 guitarthrower -
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.

2 replies

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.
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Registration date
Sunday June 14, 2009
Last seen
August 7, 2021
I think you need a macro . try to use "find" function and RECORD macro . the macro can be edited later