Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Need formula for Excel 2010?
I need to write a formula in excel that will check a column of names against a cell's value. When it finds a match I want it to then return a date from the cell next to that name.
Has anybody done this before?
6 Answers
- IXL@XLLv 79 years agoFavorite Answer
=IF(ISNUMBER (MATCH(H1,B:B,0)), INDEX(A:A, MATCH (H1,B:B,0)),"")
Col A has dates, col B has names, H1 enter name to find, formula will return date corresponding with search name
- Anonymous5 years ago
In Excel concepts, circulate to the formula section and uncheck "Use table names in formula". despite the putting, might desire to you save the workbook in 2003 layout, the equipment references will devolve to A1 form. As Simon shows, the reason of this "based reference" functionality is to get rid of between the considered necessary guesswork on the back of why a components refers to a appropriate telephone, that's complete by ability of using giving descriptive names to tables and cells.
- 9 years ago
sounds like vlookup is the formula you want. syntax will popup if you click the fx button in the middle of it but essentially it is vlookup (the cell with the value you want to look up, the range that contains the table of values, the cloumn in that range that you want returned, and use False for an exact match)
Source(s): speedypcsupport.com - How do you think about the answers? You can sign in to vote the answer.
- 9 years ago
Email me a sample spreadsheet at remusrear 'at' gmail.com and I will do that formula for you.
