Excel Formula needed

[Closed]
Report
-
 guitarthrower -
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.

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

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

CCM 2942 users have said thank you to us this month

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