I have an IF statement and I am wondering if a Vlookup can be added to the
formula?

Yes, but you'll need to provide some details on what the formula is supposed
to do.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added to the
formula?

This what my IF statement looks like. I want to pull this information for a
particular employees using Employee ID as the lookup value. Let me know if
you need more information. Thank you.

"T. Valko" wrote:

Yes, but you'll need to provide some details on what the formula is supposed
to do.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added to the
formula?

Not enough info.

Tell us what it is you're looking for. Where do we look for it? See if this
helps:

...........A..........B
1........x..........north
2........y..........south
3........z..........east

D1 = y

=VLOOKUP(D1,A1:B3,2,0)

Result = south

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
This what my IF statement looks like. I want to pull this information for
a
particular employees using Employee ID as the lookup value. Let me know
if
you need more information. Thank you.

"T. Valko" wrote:

Yes, but you'll need to provide some details on what the formula is
supposed
to do.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added to
the
formula?

Sorry, I did not include what the IF statement. Here it is:

I am pulling in information from another workbook that is look at three sets
of data and I need to grab the one that ="y". That is how the IF statement
is set up. What I want to do is look at this IF statement for a a particular
employee. So, for example, I want to do a vlookup for employee number 12345
and apply the IF statement. Let me know if you still need more information.
Thank you.


=IF('K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AW$4="y",'K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet
_04_30_09.xls]officer data'!$AS$4,IF('K:\COMP\Mary\[TEMPLATE Off Mrt Summary
Sheet _04_30_09.xls]officer data'!$BD$4="y",'K:\COMP\Mary\[TEMPLATE Off Mrt
Summary Sheet _04_30_09.xls]officer data'!$AZ$4,IF('K:\COMP\Mary\[TEMPLATE
Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BK$4="y",'K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet
_04_30_09.xls]officer data'!$BG$4,"")))/1000


"T. Valko" wrote:

Not enough info.

Tell us what it is you're looking for. Where do we look for it? See if this
helps:

...........A..........B
1........x..........north
2........y..........south
3........z..........east

D1 = y

=VLOOKUP(D1,A1:B3,2,0)

Result = south

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
This what my IF statement looks like. I want to pull this information for
a
particular employees using Employee ID as the lookup value. Let me know
if
you need more information. Thank you.

"T. Valko" wrote:

Yes, but you'll need to provide some details on what the formula is
supposed
to do.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added to
the
formula?

I don't see how VLOOKUP comes into play here. For one thing, VLOOKUP
searches to the right. Your formula is "searching" to the left.

There's nothing wrong with your formula other than it being kind of long due
to the extremely long file name.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
Sorry, I did not include what the IF statement. Here it is:

I am pulling in information from another workbook that is look at three
sets
of data and I need to grab the one that ="y". That is how the IF
statement
is set up. What I want to do is look at this IF statement for a a
particular
employee. So, for example, I want to do a vlookup for employee number
12345
and apply the IF statement. Let me know if you still need more
information.
Thank you.


=IF('K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$AW$4="y",'K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet
_04_30_09.xls]officer data'!$AS$4,IF('K:\COMP\Mary\[TEMPLATE Off Mrt
Summary
Sheet _04_30_09.xls]officer data'!$BD$4="y",'K:\COMP\Mary\[TEMPLATE Off
Mrt
Summary Sheet _04_30_09.xls]officer data'!$AZ$4,IF('K:\COMP\Mary\[TEMPLATE
Off Mrt Summary Sheet _04_30_09.xls]officer
data'!$BK$4="y",'K:\COMP\Mary\[TEMPLATE Off Mrt Summary Sheet
_04_30_09.xls]officer data'!$BG$4,"")))/1000


"T. Valko" wrote:

Not enough info.

Tell us what it is you're looking for. Where do we look for it? See if
this
helps:

...........A..........B
1........x..........north
2........y..........south
3........z..........east

D1 = y

=VLOOKUP(D1,A1:B3,2,0)

Result = south

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
This what my IF statement looks like. I want to pull this information
for
a
particular employees using Employee ID as the lookup value. Let me
know
if
you need more information. Thank you.

"T. Valko" wrote:

Yes, but you'll need to provide some details on what the formula is
supposed
to do.

--
Biff
Microsoft Excel MVP


"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added
to
the
formula?

Yes.

For example =IF(A1=1,VLOOKUP(...),"something else") or
=IF(VLOOKUP(...)=A1,B1,C1)
--
David Biddulph

"Kiley" wrote in message
...
I have an IF statement and I am wondering if a Vlookup can be added to the
formula?