J
Jason
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,'Phone Number'!$A:$G,6,FALSE)&"
"&VLOOKUP($B347,'Phone Number'!$A:$G,7,FALSE),"")
Any help is appreciated.
Jason
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,'Phone Number'!$A:$G,6,FALSE)&"
"&VLOOKUP($B347,'Phone Number'!$A:$G,7,FALSE),"")
Any help is appreciated.
Jason