My Excel formula is using my text as a cell range.

I am trying to have my formula look up my value. The problem is my text
value appears to be a cell range, for example "a75-s209". A75-s209 is a
model number that we sell. I tried to use an apostrophe, as well as
quotation marks. I could not get either one to function properly
=VLOOKUP(Inventory!"a75-s209",Inventory!A2:B74,2)

Aeryn,
If it is text, then it is not on WS Inventory as such, so use;
=VLOOKUP("a75-s209",Inventory!A2:B74,2)

NickHK

"Aeryn635" <[email protected]> wrote in message
news:[email protected]...
> I am trying to have my formula look up my value. The problem is my text
> value appears to be a cell range, for example "a75-s209". A75-s209 is a
> model number that we sell. I tried to use an apostrophe, as well as
> quotation marks. I could not get either one to function properly
> =VLOOKUP(Inventory!"a75-s209",Inventory!A2:B74,2)

Thank you so much!! Almost perfect. How do I tell it to only return an exact
match when it searches for a value?

"NickHK" wrote:

> Aeryn,
> If it is text, then it is not on WS Inventory as such, so use;
> =VLOOKUP("a75-s209",Inventory!A2:B74,2)
>
> NickHK
>
> "Aeryn635" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to have my formula look up my value. The problem is my text
> > value appears to be a cell range, for example "a75-s209". A75-s209 is a
> > model number that we sell. I tried to use an apostrophe, as well as
> > quotation marks. I could not get either one to function properly
> > =VLOOKUP(Inventory!"a75-s209",Inventory!A2:B74,2)
>
>
>

Aeryn,
Look at the 4th argument to VLOOKUP.

NickHK

"Aeryn635" <[email protected]> wrote in message
news:[email protected]...
> Thank you so much!! Almost perfect. How do I tell it to only return an
exact
> match when it searches for a value?
>
> "NickHK" wrote:
>
> > Aeryn,
> > If it is text, then it is not on WS Inventory as such, so use;
> > =VLOOKUP("a75-s209",Inventory!A2:B74,2)
> >
> > NickHK
> >
> > "Aeryn635" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am trying to have my formula look up my value. The problem is my
text
> > > value appears to be a cell range, for example "a75-s209". A75-s209 is
a
> > > model number that we sell. I tried to use an apostrophe, as well as
> > > quotation marks. I could not get either one to function properly
> > > =VLOOKUP(Inventory!"a75-s209",Inventory!A2:B74,2)
> >
> >
> >