Complex VLOOKUP Help

[mainbrain]

AJPassAmazonCondNotes2.csv

I am needing for B2 to read "Collectible - Like New" (VLOOKUP from the table starting at D2).
Then, I would like C2 to read "New and Unused" (VLOOKUP from the table starting at D7).

[FDibbins]

You did notice that you uploaded a CSV file, and not an excel workbook, right?

[mainbrain]

Thank you for pointing that out. I created it in Excel, and the save to CSV, as the upload requires. To tell you the truth, I've worked with both and am not sure what the difference is. Could you start by explaining the difference?

[FDibbins]

and the save to CSV, as the upload requires

This site does not require CSV uploads?

An excel file is just that, a file that is created in excel, and consists of rows and columns of data

A CSV (Comma Seperated Value) file is a Text file, where certain text strings are seperated by commas. Excel takes this data and breaks it apart and puts it in different columns, based on where those commas are. CSV files do not - and cannot have - formulas in them

Please upload the excel file that you have

[newdoverman]

Your file is lacking tables for the VLOOKUP. In addition, what value is being used in the lookup to return the values in column B? Are you using Data Validation drop down lists to make choices from in Column B or are the values manually entered?

Try this. Select column B then enter Data Validation, Choose List, Enter in the field at the bottom of the dialogue Collectible - Like New, Collectible - Acceptable. Hit enter. A drop down will now be available in column B with those two choices.

Now, in column C enter this and fill down:

Please Login or Register  to view this content.

This will automatically enter the correct Condition Note for the choice in column B.