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