View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Can a VLookup be added to an IF Statement?

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?