Thank you very much for your quick response, I really appreciate it.
once again thank you for your help
On Thursday, 30 July 2015 20:43:01 UTC+5, Pankaj Sharma wrote:
>
> use this
>
> =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0))
>
> or
>
> if you don't want to see #N/A error
Dear ,
Pl share the workbook with us
On Fri, Jul 31, 2015 at 2:02 AM, Rob Flott wrote:
> Why does my sheet tab calculate if there are no formulas on the tab, or
> even on the workbook?
>
> I am using Excel 2010 and my workbook has 3 tabs; each with about 3400
> rows and about 30 columns of data
Why does my sheet tab calculate if there are no formulas on the tab, or
even on the workbook?
I am using Excel 2010 and my workbook has 3 tabs; each with about 3400 rows
and about 30 columns of data.
Every time I sort the data, down in the status bar it shows 'Calculating
(4 Processors)' .
use this
=INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0))
or
if you don't want to see #N/A error so use this one
=IFERROR(INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)),"-")
*Regards,*
*PJ*
On Thu, Jul 30, 2015 at 8:01 PM, Izhar wrote:
> I need fig
My Dear How to make calculater with excel..with Vb or with out Vb.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
I need figure in color column, the figure must be taken from column L to
column R into the column G on the bases of article number, color and size.
As an example I have put some figures in column G manually, these figures
may be find in column L to R, I understand that the function we may use
over
*Hi Partner,*
*Please send resume to ma...@genuineitllc.com *
*Title : ServiceNow Express consultant *
*Location : Houston TX*
*Duration : 1 month project (maybe longer). *
Let me know if you have anyone with a *ServiceNow background.* Brief
description of what they are seeking is below:
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Title : Microsoft Threat Management*
*Location : Atlanta,GA*
Responsibilities include:
• Processing customer website unblock requests on Websense and
Microsoft Threat Management Gateway proxy servers
• Resolving com
