Hi Rahul,
Sheet 2 row A3 item description starting i given space that time there is no code
is it possible before the item description there was space in some cases
Hi,
I need formula in excel.
Sheet name : Master list
Sheet name : Sheet2
I have item code and item description in the master list.
in Sheet2 I have only items description need formulas if Approximate match item description return item code in sheet2
Herewith attached Sample data sheet...
Hi, Friends
here with attached sample data sheet for your understanding
Ref with the C6=item code & X6= Request number match with the PO DETAILS SHEET S&T & AD
The PO NUMBER AD2 is reflect in the formulas required sheet AA6 I given one example
Best regards
Aelmareddy
Hi,
Friends,
Please help me to put the formulas for
Sum Only Positive Or Negative Numbers In Excel with criteria match
here with attached sample excel sheet
best regards
Aelmareddy
Dear Friends
Please help me how to get the data with one ref.. item code and matching with FR no cell
I have data in three sheets. Based on the one or two ref.. i need auto fill the data into 1 report sheet
Please see the attachment
Best Regads
Aelmareddy
Dear Bosco,
Hi,
Please see the attached report in the same way is possible i can see the data in report sheet ( in report sheet the data has to be auto fill )
Dear Friends
Please help me how to get the data with one ref.. item code and matching with FR no cell
I have data in three sheets. Based on the one or two ref.. i need auto fill the data into 1 report sheet
Please see the attachment
Best Regads
Aelmareddy
Dear Bosco,
I saw the attachment i was added the item code 15 times in a different PO numbers
But i am getting only 2 results only
Please see the attachment
Thanks & Regards
Aelamreddy
Hi,
Friends
Help me in formula. I trying to get all the information if we placed the item code in the column formula sheet C6:C7 i need all the information in one place
Please find the sample sheet i was attached.
Item code Vs = PO NUMBER , PO QTY IN DETAIL, SUPPLIER NAME
Or suggest me in...
Dear Friends,
Please help me to complete the formula. I need Vlookup to match the data from data sheet A:B
Herewith attached sample sheet
Thanks & Regards
Aelma reddy
Dear Bosco
Thanks !
Please see the attachment i added small comments on that in one condition same PO number is repeating and i also i added PO Qty when work order number and PO number match the PO QTY to be reflected in D2: D15
Thanks & Regards
Aelmareddy
Dear Friends
Help me in V lookup formula. When i apply the formula same data is repeating multiple times
Herewith attached excel sheet
Thanks & Regards
Aelmareddy