Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

From sheet 2 cell find sheet1 name then value

Frank McLean, on Saturday 4 October 2008 à 10:24:04
Hello,

I am using Excel 2003, Windowx XP Professional, and Internet Explorer 7

In one Excel 3003 example workbook sheet1 contains data copied in from Internet Explorer 7 that keeps changing position on the sheet. From a cell, EG C5, in sheet2 I want to use functions to find a name in Sheet1 and pull the value on the same row say seven columns to the right back into sheet2 cell C5.

My knowledge of Excel is very limited but this would seem to be a simple common thing to have to do, but have been unable figure it out. If this has been answered elsewhere I appologise, this is my first time to this forum which I found with google.

TIA
Configuration: Windows XP
Internet Explorer 7.0
Reply to Frank McLean  Report this message to moderators Go to last message

1


  • 1    This message seems useful, vote!
  • Ce message ne vous semble pas utile, votez !
  • Report this message to moderators
 fedexpro, on Saturday 4 October 2008 à 14:54:24
here is a link where you will get many useful tips just tro to see if you can get what you are in search of
   
Reply to fedexpro
Ask your question Reply

Résultats pour From sheet 2 cell find sheet1 name then value

Copy data into next empty cell in new sheet Hello, I am trying to make a 2 sheet workbook which has the input details in Sheet1 A1 and this is changed weekly but the info in this cell should then be inserted into the first blank cell in Column A in Sheet 2. I have tried this code (below) but it... en.kioskea.net/forum/affich-16567-copy-data-into-next-empty-cell-in-new-sheet
Excel Find Short Name in Full Name Hello, I have a excel problem!! I have an A column with short name cell: bill gates I have a B column with full name cell: Sr. Bill gates Junior... How find Column A name in Column B? Thanks!! en.kioskea.net/forum/affich-13944-excel-find-short-name-in-full-name
Finding computer name using IP I need to find the computer name of one PC connected in LAN (joined to domain). I have the IP address of terminal. how i will find the computername? kindly advice Thanks and Regards en.kioskea.net/forum/affich-12027-finding-computer-name-using-ip

Résultats pour From sheet 2 cell find sheet1 name then value

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell
How do I find Word's keyboard shortcuts?To deal with shotcuts you have several possibilities. 1- Some keyboard shortcuts are listed next to the items in the main menu (just open menu list and check out). 2- You can also find shortcuts listed in Microsoft Help (lookup "shortcuts" or... en.kioskea.net/faq/sujet-9-how-do-i-find-word-s-keyboard-shortcuts
1 2 3 Next

Résultats pour From sheet 2 cell find sheet1 name then value

Updation of worksheet cell valueHello, I have a worksheet named "Sheet1". In the cells P1 to P5, I have hardcoded the values 1,2,3,4 and 5. These values are taken as drop down in cell "A1" (Data->Validation->List). I have a worksheet named "Sheet2", whose contents are the same as... en.kioskea.net/forum/affich-30577-updation-of-worksheet-cell-value
SUMIF or VLOOKUP? a range of cellsHi, I'm trying to perform a VLOOKUP or SUMIF on a range of data in another sheet. Eg sheet 1 is where i the formula is. Col C valuename ( formula) Sheet 2 has my data on, in the format:- A B C D E ValueName 2 4 2 2 2 I can obviously lookup... en.kioskea.net/forum/affich-3857-sumif-or-vlookup-a-range-of-cells
Excel Macro; move row os x 10.4.8Hello, I am trying to make a macro that will move an entire row to another sheet based on a value of 1-4 in column G. For instance if colG=1 move to sheet 2 ... How would I go about this/ en.kioskea.net/forum/affich-1621-excel-macro-move-row-os-x-10-4-8
1 2 3 Next

Résultats pour From sheet 2 cell find sheet1 name then value

Download The Love CalculatorLove is a big word, then all means are good to find it. The name of each can say about it on compatibility between two persons a lot. The Love Calculator is a program which counting affinity between two individuals. It is not a precise science,... en.kioskea.net/telecharger/telecharger-756-the-love-calculator
1 2 3 Next

Résultats pour From sheet 2 cell find sheet1 name then value

New internet domain names in 2009: ICANNPeople surf the Internet in Beijing in 2007. Internet users should soon be able to use new domain names such as .love, .paris or .bank if one of the world wide web's biggest shakeups is approved this week as expected by the web regulator ICANN.... en.kioskea.net/actualites/new-internet-domain-names-in-2009-icann-10478-actualite.php3
1 2 3 Next

Résultats pour From sheet 2 cell find sheet1 name then value

Internet - Domain names Each computer directly connected to the Internet has at least one specific IP address. However, users do not want to work with numerical addresses such as 194.153.205.26 but with a domain name or more specifically addresses (called FQDN addresses)... en.kioskea.net/internet/dns.php3
Computer - ATA, IDE and EIDE The ATA (Advanced Technology Attachment) standard is a standard interface that allows you to connect storage peripherals to PC computers. The ATA standard was developed on May 12, 1994 by the ANSI (document X3.221-1994). Despite the official name... en.kioskea.net/pc/ide-ata.php3
Spreadsheets - Cell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3
1 2 3 Next