Search : in
By :

From sheet 2 cell find sheet1 name then value

Last answer on Oct 4, 2008 2:54:24 pm BST Frank McLean, on Oct 4, 2008 10:24:04 am BST 
 Report this message to moderators

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

Best answers for « From sheet 2 cell find sheet1 name then value » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 Show Excel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
[LAN] - Finding another computer’s name using IP Show[LAN] - Finding another computer’s name using IP Issue Solution Issue I need to find the computer name of one PC connected in LAN (joined to domain). I have the IP address of terminal. How to find the computername? Solution To...
Find an unused domain name ShowFind an unused domain name Finding an unused domain name is quite troublesome and tedious (a lot of time is required) Here is a site that could help many Webmaster for this purpose: Domize.com is a site to easily check the availability...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Download The Love Calculator ShowLove 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,...
Email ShowWhat is electronic or email? This is one of the most widely used services on the internet making it possible to send messages in the form of a text file. The Académie française uses the name "mél" while the Canadians (generally more imaginative)...

1

 fedexpro, on Oct 4, 2008 2:54:24 pm BST
  • +17

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