Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel - linking cells - diferent
Name: piske Date: February 2, 2007 at 08:19:06 Pacific OS: Windows xp CPU/Ram: AMD2400 ram 1GB Product: EPOX
Comment:
Is it possible to do this... In sheet1 I have A1 to A1000 - numbers B1 to B1000 - product name In sheet2 In cells A1....A1000 I want to manualy input numbers in no order (ie 57, 127, 300...) and in cells B2...B1000 I want product names from sheet1 automaticaly. If I enter number 22 in cell A1 in sheet2 then cell B2 in sheet2 must fill with content from cell B(22+1) from sheet1. Is it possible?
Name: templarg Date: February 3, 2007 at 14:20:06 Pacific
Reply:
sorry I don't have excel installed on this machine so cannot remember the exact syntax but one of the "LOOKUPW formuluae should be able to do what you need...if the cells on sheet 1 Column A are sorted you might be able to use HLOOKUP in column B on sheet2. e.g cell Sheet2!a2=22 then in cell b1 on sheet2 the formula would look something like:-
=hlookup(a1,Sheet1!A1:B1000,2)
0
Response Number 2
Name: templarg Date: February 3, 2007 at 15:18:19 Pacific
Reply:
Sorry - lookup formulae should be something like
=VLOOKUP(A1,Sheet1!A1:B1000,2,FALSE)
0
Response Number 3
Name: Jennifer SUMN Date: February 6, 2007 at 05:10:18 Pacific
Reply:
Bryco would be the one to help you. PM him, and I'm sure he'll assist.
Life is more painless for those who are brainless.
0
Response Number 4
Name: piske Date: February 8, 2007 at 01:52:54 Pacific
Summary: I would like to pipe the results of all the applications on my Citrix farm to an excel file which is fine but I would also like that excel file to update the tables in another excel file so that I alw...
Summary: I need to have interactive reporting system, i tried to use crystal reports but the system can not give me interactive reports. when you need another report we have to generate a new one. i developed ...
Summary: Hi, I am trying to figure out which function that I need to use. I essentially have two columns; Column A consists of account #s and Column B consists of codes that correspond to that account. For ex...
0 
