In Sheet "Orig", Cell B3 I have the part number that I am looking for the price.
In Sheet "Vendors" I have all of the price lists from all of my vendors.
In Sheet "Vendors" column "C" I have matching part numbers for all of my vendors.
In Sheet "Vendors" column A I have the names of the vendors such as below:
A B C D E
[TABLE="width: 318"]
Vendor
[/td][td]Brand
[/td][td]Part#
[/td][td]Other#
[/td][td]Cost
[/td][/tr][tr][td]SW
[/td][td]Xerox
[/td][td]106R02307
[/td][td][/td]
[TD="align: right"]$52.90[/TD]
SW
[/td][td]Xerox
[/td][td]108R00795
[/td][td][/td]
[TD="align: right"]$36.50[/TD]
SW
[/td][td]Xerox
[/td][td]108R00795
[/td][td]108R00795
[/td]
[TD="align: right"]$46.75[/TD]
LMI
[/td][td]Xerox
[/td][td]106R01486
[/td][td][/td]
[TD="align: right"]$49.00[/TD]
LMI
[/td][td]Xerox
[/td][td]106R01530
[/td][td][/td]
[TD="align: right"]$52.90[/TD]
LMI
[/td][td]Xerox
[/td][td]106R02307
[/td][td][/td]
[TD="align: right"]$59.90[/TD]
LMI
[/td][td]Xerox
[/td][td]108R00795
[/td][td][/td]
[TD="align: right"]$74.90[/TD]
[/TABLE]
I want a formula that finds the matching part number from Sheet "Orig" Cell B3 in Sheet "Vendors" Column "C" and only returns the matching price for that part number from the LMI prices. It is like a Vlookup but would narrow it down to only inclued the search to the LMI rows.
thanks