when I am using IF function, if the statement is false, I want that cell remain the existing information unchanged.
how can I do this?
when I am using IF function, if the statement is false, I want that cell remain the existing information unchanged.
how can I do this?
don't put any value in the false area(do nothing)
=IF(B1="",1+2,B2)
or is there anything else you can elaborate more if possible.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi,Sir.
Actually, my problem is that I want to update information from "sheet 1" to "sheet 2" base on the same number and item.
what am I doing now is: I copy number from sheet 1 and find it in sheet 2.
then I update information in sheet 2, column W to AG.
I need to do it for every part number in sheet 1 repeatively. It is very tedious.
So I want to find a way that can auto this process
none of your numbers match between the 2 files. IF there were any matches, the following formula would return the info you want...
=VLOOKUP($N2,'[sheet1.xlsx]Inbound-PGR-Done'!$A$2:$W$39,COLUMN(W$1)-13,FALSE)
adjust ranges and file names as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
duplicate post (by me) - deleted
Hi,sir, where should I put this formula in?
could you put this formula inside the excel sheet then show me?
I put that in sheet2 file, cell W2. copy it down and across
Actually in sheet 2, there are lots of data between W to AG column. I just want to make sure all data from sheet 1 is updated to sheet 2. however, remian other data unchanged in sheet 2 W to AG column, is there a way to do this ?
then just copy that down in the columns you need
sometimes I need to update 100+ numbers, it is very tedious, is there a way can auto this process?
Any one could help me on problem in #3.
I am stuck for very long time. thank you so much.
Look at post #4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks