EXCEL SPREADSHEET NEED FORMULA PLEASE : (

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 replies

Posts
8926
Registration date
Friday May 15, 2009
Status
Member
Last seen
October 7, 2010
2,106
Hi there,

Please do not duplicate question on forum,

Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
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!
I used SpeedShare.com please refer to: http://www.speedyshare.com/files/23128292/scrnsht.bmp

Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Can you upload an EXCEL file.