Vlookup

[bmonaweck02]

I am looking for a way to use a VLOOKUP. What I am trying to do is have a VLOOKUP value for a piece of equipment. But what I would like to do is have the value it would be trying to lookup be like "PU202" but I don't want to have to create a table that has all of my equipment and their truck numbers. I just want to have a table that says the rate for this type of equipment. And not all of the equipment #'s.

If I made a table and the PU column said PU000 would the VLOOKUP function be able to lookup PU202 on a table that only says PU000 or PUXXX or something like that?


Thanks in advance.

Brian