Excel help, please! on Yedda - People. Sharing. Knowledge.

Posted Answers

yoavdothan

618 answers

1147 thumbs up

There is a function that does it: VLOOKUP

For example : you have a column filled with data - column A

You have a single cell (c1) that you wish to compare to all the data in column A : vlookup(c1,a1:a27,1,false). This will just give you if there is a match or no.

but I suggest that you add another column with the number of rows so you can get immediately the row where the match appears. So let us add Column b with the numbers , and the function will become: vlookup(c1,a1:a27,2,false)

Posted 2 years ago ( permalink )

In reply to Jupiter's question

Rated as
Best Answer

Report Abuse

Helpful?

Sign in to participate

Got an answer for Jupiter? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:

Problem with Excel

There's something in Excel (2003 SP2) that really annoys me: I often have to copy a range of cells from one place to another. If ...

Submitted by drowssorc 1 year ago

2 answers
viewed 565 times

Last answer posted 1 year ago by rivierabrian

Do you know a program that can turn .pdf files to .xls ?

Do you know a free program that can turn *.pdf files to *.xls ? I am stuck with a ton of spreed sheet data in acrobat and I need ...

Submitted by bergerui 2 years ago

2 answers
viewed 474 times

Last answer posted 2 years ago by bergerui

Youtube accelerator

cannot start multi-connection. why. any file i missing? maybe in windows system folder

Submitted by ulat 1 year ago

1 answer
viewed 1549 times

Last answer posted 9 months ago by george

» More...

Explore Related Posts in Forums

how to read data from excel and put in array?

Hi, Ineed to read data from excel and put the data read into the array. The excel file typically the toolkit don't matter to me. because it uses the activex properties and methods from microsoft...

Control Arrays in VB.Net

Software Development, Linux Operating System, UNIX OSPrintDiggEmaildel.icio.usBlogmore... to implementing control arrays in VB.Net? It doesn't appear that they exist in VB.net, at least

Office 2008 documents cannot be opened on Office 2004 Mac

, they can:-) However, if they were saved in Office 2008 native OOXML (.---x) format... /microsoftofficeopenxmlfileformatconverter.html Other programs - such as those in the Open...

» More...

Feed - Subscribe to changes to this Q&A Blog

Explore Related Videos

Lecture - 14 Software Design - Primary...

Lecture Series on Software Engineering by Prof.N.L. Sarda, Prof. Umesh Bellur,Prof.R.K.Joshi and Prof.Shashi Kelkar, Department of Computer Science & Engineering ,IIT Bombay . For more details on NPTEL visit http://nptel.iitm.ac.in

Lecture - 21 Software Metrics and Quality

http://www.4xrazor.com,advanced forex...

http://www.4xrazor.com,advanced forex signal system, online currency trading system, automated forex trading software, forex online software trading, forex trading software,

Oracle takes over Primavera Software

www.EmploymentCrossing.com Oracle announced it is acquiring a major project management software supplier, Primavera Software of Bala Cynwyd (balla kenwood), Pennsylvania. No price was set on the deal, expected to close later this year. An Oracle spokesperson said the Redwood City, California software giant was making the acquisition to tailor project management toward such industries as engineering, construction, aerospace, defense, utilities, oil and gas, manufacturing, and professional services. "Enterprise project portfolio management is moving to the forefront of business strategy for industries that are managing complex and capital intensive projects," Oracle president Charles Phillips said in a statement announcing the acquisition. Primavera CEO Joel Koppelman said Primavera will become a global business unit of Oracle, continuing to function as a developer of project management software products. Many Oracle application customers are found in project-intensive industries, giving Oracle a chance to sell them project management as well as CRM, human resources, financial applications, business intelligence, and databases. To find project manager jobs in your area, click here.

Hak5 - Episode 405 - Windows USB Booting,...

Booting Windows from a USB key using the Windows Automated Installation Kit. Unlocking the Fon and Installing Jasager -- Illustrated. Desktop and meeting collaboration using DimDim, the free open source online collaboration software. Turn your Windows desktop into a 3D spaces cube, and more!

Open Question

Excel help, please!

Topics: