I am having a huge problem here and I looked everywhere for an answer but
cant find anything that works. Anyways here is my problem.

In cell C17 I need to insert a IF statement that test whether the value in
call B17is equal to an empty text string. If so I need it to display an empty
text string; otherwise I need to use the VLOOKUP to look up the item that I
created in a table I named Item_ID which has to be an exact match.

So basically, if someone selects cell B17 they can click it and a list
appears to which they select a product. In C17 im trying to test what I said
above.

Thanks to anyone that can help me

Not real clear what you want...maybe this:

=IF(B17="","",VLOOKUP(B17,...........))

--
Biff
Microsoft Excel MVP


"Ultrasayjin" wrote in message
...
I am having a huge problem here and I looked everywhere for an answer but
cant find anything that works. Anyways here is my problem.

In cell C17 I need to insert a IF statement that test whether the value in
call B17is equal to an empty text string. If so I need it to display an
empty
text string; otherwise I need to use the VLOOKUP to look up the item that
I
created in a table I named Item_ID which has to be an exact match.

So basically, if someone selects cell B17 they can click it and a list
appears to which they select a product. In C17 im trying to test what I
said
above.

Thanks to anyone that can help me

Ok, thanks so much. I finally got it to work..!! Today your my hero.! I had
some syntax errors and the "" I had in as Blank. So this works now, thanks
again so much

"T. Valko" wrote:

Not real clear what you want...maybe this:

=IF(B17="","",VLOOKUP(B17,...........))

--
Biff
Microsoft Excel MVP


"Ultrasayjin" wrote in message
...
I am having a huge problem here and I looked everywhere for an answer but
cant find anything that works. Anyways here is my problem.

In cell C17 I need to insert a IF statement that test whether the value in
call B17is equal to an empty text string. If so I need it to display an
empty
text string; otherwise I need to use the VLOOKUP to look up the item that
I
created in a table I named Item_ID which has to be an exact match.

So basically, if someone selects cell B17 they can click it and a list
appears to which they select a product. In C17 im trying to test what I
said
above.

Thanks to anyone that can help me

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ultrasayjin" wrote in message
...
Ok, thanks so much. I finally got it to work..!! Today your my hero.! I
had
some syntax errors and the "" I had in as Blank. So this works now, thanks
again so much

"T. Valko" wrote:

Not real clear what you want...maybe this:

=IF(B17="","",VLOOKUP(B17,...........))

--
Biff
Microsoft Excel MVP


"Ultrasayjin" wrote in message
...
I am having a huge problem here and I looked everywhere for an answer
but
cant find anything that works. Anyways here is my problem.

In cell C17 I need to insert a IF statement that test whether the value
in
call B17is equal to an empty text string. If so I need it to display an
empty
text string; otherwise I need to use the VLOOKUP to look up the item
that
I
created in a table I named Item_ID which has to be an exact match.

So basically, if someone selects cell B17 they can click it and a list
appears to which they select a product. In C17 im trying to test what I
said
above.

Thanks to anyone that can help me