using a vlookup, can i use isblank to show an empty cell

I am trying to create an excel solution using a vlook up, but in the formula
cell i would like to cell to be blank if nothing has been entered in the
reference cell

Thanks
Sandy

Sandy

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

Regards

Trevor


"Sandy" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create an excel solution using a vlook up, but in the
>formula
> cell i would like to cell to be blank if nothing has been entered in the
> reference cell
>
> Thanks
> Sandy

Hi Sandy,

Try this format with ranges to suit your sheet.

=IF(ISNA(VLOOKUP(B2,$H$4:$I$18,2,FALSE)),"",VLOOKUP(B2,$H$4:$I$18,2,FALSE))

HTH
Regards,
Howard

"Sandy" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create an excel solution using a vlook up, but in the
>formula
> cell i would like to cell to be blank if nothing has been entered in the
> reference cell
>
> Thanks
> Sandy

Hi!

A1 = lookup value (reference cell)

Try this:

=IF(A1="","",your_vlookup_formula_here))

Biff

"Sandy" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create an excel solution using a vlook up, but in the
>formula
> cell i would like to cell to be blank if nothing has been entered in the
> reference cell
>
> Thanks
> Sandy

Hi Trevor,

Thanks very much for the solution, it worked a treat

Thanks Again
Sandy

"Trevor Shuttleworth" wrote:

> Sandy
>
> =IF(B2="","",VLOOKUP(B2,....)
>
> Regards
>
> Trevor
>
>
> "Sandy" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to create an excel solution using a vlook up, but in the
> >formula
> > cell i would like to cell to be blank if nothing has been entered in the
> > reference cell
> >
> > Thanks
> > Sandy
>
>
>

You're welcome. Thanks for the feedback


"Sandy" <[email protected]> wrote in message
news:[email protected]...
> Hi Trevor,
>
> Thanks very much for the solution, it worked a treat
>
> Thanks Again
> Sandy
>
> "Trevor Shuttleworth" wrote:
>
>> Sandy
>>
>> =IF(B2="","",VLOOKUP(B2,....)
>>
>> Regards
>>
>> Trevor
>>
>>
>> "Sandy" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to create an excel solution using a vlook up, but in the
>> >formula
>> > cell i would like to cell to be blank if nothing has been entered in
>> > the
>> > reference cell
>> >
>> > Thanks
>> > Sandy
>>
>>
>>