Hi,

I need formula for below mentioned query:

I am having very big calculation in Sheet-1. If i will give input in A1 & B1
of Sheet-1 i will get answer in C1 from very big calculation.

Now, i am having Sheet-2 which is having various combination of input
required in A1 & B1 of sheet-1.

What i need is, i wanted to put formula in sheet-2 as per below:

Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
Sheet-2 from C1 of sheet-1.

if you need to understand problem further please provide your mail ID so
that i can explain to you more.

Regards,

Hardik

HI Hardik,

Look at the DataTable command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Hardik Shah" wrote in message ...
| Hi,
|
| I need formula for below mentioned query:
|
| I am having very big calculation in Sheet-1. If i will give input in A1 & B1
| of Sheet-1 i will get answer in C1 from very big calculation.
|
| Now, i am having Sheet-2 which is having various combination of input
| required in A1 & B1 of sheet-1.
|
| What i need is, i wanted to put formula in sheet-2 as per below:
|
| Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
| Sheet-2 from C1 of sheet-1.
|
| if you need to understand problem further please provide your mail ID so
| that i can explain to you more.
|
| Regards,
|
| Hardik

Dear Niek,

Thank you for your reply. But still i am not getting what i required. I have
sent you mail with the excel sheet on mail ID :

Please check and revert back.

"Niek Otten" wrote:

HI Hardik,

Look at the DataTable command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Hardik Shah" wrote in message ...
| Hi,
|
| I need formula for below mentioned query:
|
| I am having very big calculation in Sheet-1. If i will give input in A1 & B1
| of Sheet-1 i will get answer in C1 from very big calculation.
|
| Now, i am having Sheet-2 which is having various combination of input
| required in A1 & B1 of sheet-1.
|
| What i need is, i wanted to put formula in sheet-2 as per below:
|
| Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
| Sheet-2 from C1 of sheet-1.
|
| if you need to understand problem further please provide your mail ID so
| that i can explain to you more.
|
| Regards,
|
| Hardik

On Apr 21, 1:52*pm, Hardik Shah
wrote:
Dear Niek,

Thank you for your reply. But still i am not getting what i required. I have
sent you mail with the excel sheet on mail ID :

Please check and revert back.



"Niek Otten" wrote:
HI Hardik,

Look at the DataTable command

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Hardik Shah" wrote in ...
| Hi,
|
| I need formula for below mentioned query:
|
| I am having very big calculation in Sheet-1. If i will give input in A1 & B1
| of Sheet-1 i will get answer in C1 from very big calculation.
|
| Now, i am having Sheet-2 which is having various combination of input
| required in A1 & B1 of sheet-1.
|
| What i need is, i wanted to put formula in sheet-2 as per below:
|
| Put value of Sheet-2 A1 & B1 in A1 & B1 of sheet-1 and write answer in C1 of
| Sheet-2 from C1 of sheet-1.
|
| if you need to understand problem further please provide your mail ID so
| that i can explain to you more.
|
| Regards,
|
| Hardik- Hide quoted text -

- Show quoted text -

Hi Hardik,
Word of caution.
Don't send file attachments to anybody without their prior consent.
AND do not post anybody's mail id directly in NG. It will flood their
mail box with thousands of spam mails.

Regards,
Madiya