Are you saying that you want a LIST of all matches of "Office"
123 Office 310 555-1212
123 Office 310 555-1212
123 Office 310 555-1212
If so, use datafilterautofilterfilter on type for officecopy/paste.
Record a macro to do it
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jason" wrote in message
...
Hello,

I have a question about a vlookup. I have the below criteria

Supplier Phone Type Prefix Phone number
123 Cell 310 555-1111
123 Office 310 555-1212
123 "Blank" 310 555-1213

In another sheet, I have one supplier and want a column for each phone
type.
My below formula won't work because it looks to be only doing a lookup on
the first record (123) it finds. What can I do to have it search for the
correct "Phone type"

=IF(VLOOKUP($B347,'Phone
Number'!$A:$G,5,FALSE)="Office",VLOOKUP($B347,'Pho ne
Number'!$A:$G,6,FALSE)&"
"&VLOOKUP($B347,'Phone Number'!$A:$G,7,FALSE),"")

Any help is appreciated.

Jason