vlookup & if

Hey guys, wondering if you could help me out with this. I have a VLOOKUP formula right now that looks up a value X3444 in a table and returns the 10th column. The problem is that there are multiple entries of X3444 in the table. Now, there is another column, let's say column 5, in this table...

Hi, I am trying to add a new features to an excel file the New Home Sales company I work for uses for quoting. The feature I wanting to add relates to our display homes and their upgrades. I am thinking :confused: that a formula with both IF and VLOOKUP would be the way to go but I am not sure...

Hi everybody-I'm stuck and need some help here. I'm trying to write a function that looks for an ID # on another page (EXPORT) and pulls a designated value (XXL) IF it finds a partial text match (XXL) within text that will read "Custom XXL - Protein Powders" + a few other variations that all...

Hi Experts, I come back to you for help with another problem. I have 2 workbooks. Workbook 1 contains: Date Group Workbook 2 contains: From Date To Date Criterion Problem: I want a formula that would perform a vlookup on a criterion to fetch group (text) only if the date in workbook 1...

Hi, I currently have the following VLookup formula looking up info from another table: =IFERROR(VLOOKUP($D$7,Table1,5,FALSE)," - ") And It's great when there is no text in the cell or if the unique lookup value doesn't exist. However, when the field is blank that it is trying to lookup, it...

Hi, I have two database, let's say DBA and DBC. Both the databases have invoice numbers as common while DBC has additional filed of Sale Date while DBA has additional field of Purchase Date. I want to run vlookup on DBA by basing on the invoice number so that the following output is...