Previous Topic Next Topic

EXCEL SPREADSHEET NEED FORMULA PLEASE : (

Closed
LRS - Jun 24, 2010 at 10:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 25, 2010 at 03:38 PM
Hello,

I am STUCK and it's driving me bonkers!!!! I have a 2003 EXCEL SPREADSHEET ISSUE:

If Column B (FROM worksheet TEST PAGE 1)
MATCHES what's in column 'A' on (Worksheet Page 2)
THEN take what's in Column 'E' FROM (Worksheet Page 2)
AND place it in Column 'F' on worksheet TEST PAGE 1)

(If there aren't any matches...??? I suppose it would show up blank, yes?)

Also, this is for a report that will be run on a monthly basis...sooo can this be done by writing a simple script to run a macro? I dunno...I've never done either...it's all new to me.

Thanks in advance for your help.


2 responses

Answer 1 / 2
closeup22 Posts 8923 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,099
Jun 24, 2010 at 10:48 AM
Hi there,

Please do not duplicate question on forum,

Thanks
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 24, 2010 at 06:33 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
LRS
Jun 25, 2010 at 10:36 AM
Okay, here's what I need:

If Column 'A' (FROM worksheet LRS_PAGE 1) Tab
MATCHES what's in column 'A' on (LRS_PAGE 2) Tab
THEN take what's in in "the related cell"; from Column 'D' FROM (LRS_PAGE 2) and
populate that 'VALUE' into Column 'C' (ON worksheet LRS_PAGE 1)

This will be a monthly report so is there a macro/script that I could run on a regular basis?

Please let me know ASAP...THANKS!
0
LRS
Jun 25, 2010 at 10:38 AM
I used SpeedShare.com please refer to: http://www.speedyshare.com/files/23128292/scrnsht.bmp

Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 25, 2010 at 03:38 PM
Can you upload an EXCEL file.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response