Get instant live Excel expert help with LOOKUP Function

I am trying to lookup data from one sheet and return it into another spreadsheet based on a cell value.

I have a list of goodies on my spreadsheet, what I want is to have a dropdown list on the 2nd sheet and will automatically lookup for the price?

I am trying to perform an INDEX MATCH function with text data. Basically, I am trying to match a text field in one table, with a text field in another table, to pull out its corresponding identity code. I keep getting an N/A error, when when I perform a MATCH function itself, but the text is clearly present in the lookup table.

I am trying to use nested IF and lookup commands to create multiple outputs from a series of 3 drop down menus. For example: If drop down menu options are A, B, and C then the result will be 0.1 but if it's A, C, C, then the result will be 0. It's sort of a calculation chart/generator type thing.

I want to see if there are common names from column A on both sheets and common amounts on both sheets using v lookup . my formulas are failing.

I have a nested LOOKUP formula which is not working

CRITICAL REPORT Need. Help with INDEX/MATCH lookup and pivot.

I need a formula to lookup a certain cell value in a table and display the data in the cell at the top of the column it is in. (my hlookup isn't working)

I have a list of candidate info on one tab, that i want to use to automatically populate cells in another tab once one value is entered in a cell to identify the candidate. No matter what i try with the lookup or match formulas, i cannot get it to work

trying to lookup a serial number form my first sheet and match it to another sheet in a column which the serial may have a few extra characters at the end