Get instant live Excel expert help with VLOOKUP functions

HI, im having trouble with an excel formula, I wish to populate sheet 1 (which has drug names down the side and protein names along the top, with "fit" values in sheet 2. The fit values returned from sheet 2 should correspond to the top row of sheet 1 (e.g. 2bu5_v fit value, found in sheet 2 corresponding to 6-mna, should be returned in sheet 1 B4. and then so on and so forth to populate the entire sheet. I think a VLOOKUP function is required, but cant get it to work.....

vlookup from sheet1 column L to sheet2 column A use match to pull ID in column B from sheet 2 to Column Q in Sheet1 NOTE: If N/A exist in Sheet1 column L skip and do not change the ID associated in column Q (These are highlighted in yellow as NEUTRAL)

based on Column A sheet 1perform a vlookup to sheet 2 column a and return column b ID to column b in sheet 1

I'm trying to use the vlookup formula to identify specific countries for IP addresses on one worksheet by referencing information on another worksheet. I'm not exactly sure how to use data from two separate worksheets.

when I complete a vlookup and want to drag the formula down to the rest of my rows it just keeps copying the first v look up response. How do I make it format to pick up the formula?

I want to run a formula where: if i vlookup based on cell1 and the returned value contains text found in cell2, then another vlookup will be run

Hi guys, I have a big database that I want to connect to another database. I want to get a value for from one of the databases into the first, but only if the name and the builder of the particular vessel is the same. I am trying with vlookup, index and match, but I can not get it to work. Can you help me?

In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14. Use the range A5:H11 as the table array

I have two worksheets. In first one, user selects an item from drop down menu and second sheet contains all the items and associated numbers for each item. When a user selects Item4 from drop down menu, vlookup gets the associated numbers for it in next cell. Now, I need to have button/checkbox/anything that can divide, multiply or revert back to original the number associated with the item number. Eg. Sheet2 got Item1 that values 1, 5, 0 each in their own cell. Below is Item2 that got values 0, 5, 0 Sheet1 allow user select multiple items below each other and at last there is SUM function which sums all numbers in each column (1+5, 5+5, 0+0) What is hard here, is when user wants to divide Item1's values by 2 to 0,5 - 2,5 - 0 without rendering the vlookup formula useless.

Stuck with a VLOOKUP issue in Excel. Have tried everything from looking up numbers to text, text to columns, copied data into a new sheet, pasted values only, text to columns, lookup values as text and nothing works. I am not new to troubleshooting VLOOKUP issues but this has me stumped.