Data input = automatic formula input

[Rbboon]

Is there a way that a formula can be automatically applied to a cell if specific data is input in another?

For example:
If "vendor" is typed in B2, (specified formula) is automatically embedded in F2.

 

[Jonmo1]

In F2, put

=IF(B2="vendor",specifiedformula,"")

 

[Rbboon]

In F2, put

=IF(B2="vendor",specifiedformula,"")

Thank you for replying:
I had previously tried it but it comes back with an #value error.

 

[Rbboon]

Is is because the specified formula is linked to another workbook?

 

[Jonmo1]

Can you post what the secified formula should be ?
And confirm that the specified formula in fact works by itself.

 

[Rbboon]

Yes, the formula works by itself: VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$1:$1048576,4,0)

Thank you for the help
[TABLE="width: 64"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[DushiPunda]

And what was the full formula you put in F2?

Based on this from Jonmo1:
=IF(B2="vendor",specifiedformula,"")

The formula you should try is:
=IF(B2="vendor",VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$1:$1048576,4,0),"")

 

[Jonmo1]

Try

=IF(B2="vendor",VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$1:$1048576,4,0),"")

Though I recommend not referencing the entire sheet in your vlookup.
Try
=IF(B2="vendor",VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$A:$D,4,0),"")

 

[Rbboon]

Try

=IF(B2="vendor",VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$1:$1048576,4,0),"")

Though I recommend not referencing the entire sheet in your vlookup.
Try
=IF(B2="vendor",VLOOKUP($B73,'C:\PD\[Invoicing Lookup.xlsx]Invoice VLOOKUP'!$A:$D,4,0),"")

THANK YOU!!!! It works like a charm.
Why does excluding the sheet as a reference make such a difference?

 

[Jonmo1]

You're welcome.

Not sure I follow what you're asking now.
Are you referring to me saying not to reference the entire sheet ?
I mean that $1:$1048576 is actually a reference to every single cell on the entire sheet.
That gets loaded into memory when you run the formula.
Changing it to A:D greatly reduces the number of cells referenced and loaded into memory.
In fact, it would be even better if you reduced it to a specific number of rows as well, like A$2:D$1000