Are you stuck on Excel or Google Sheets?

Hi, I have a problem with vlookup formula, I am not sure what am I doing wrong but it seems to not be working

Question 5. In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula.

Vlookup or match help, having issues creating the formula

I have an IF statement that works. Its pretty complicated with VLOOKUP. But i need to make this an OR statement and i keep getting errors and can't figure out the formula.

When i do a VLOOKUP, I cannot autofill the formula for the rest of the table. It copies the initial cell that the VLOOKUP was done.

Excel formula returns a lot of #N/A results but unsure how to incorporate the IFERROR function to remove them, Can anybody help? =IF($A3="","",IF(VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE)="","",VLOOKUP($A3,'SHAREPOINT LINK]Jobs Log'!$A:$Y,17,FALSE))) I have removed the link to the sharepoint doc as it gives away the company name so where it says 'SHAREPOINT LINK' just ignore, I don't think anyone needs to know that info. to get the formula to work. Thanks in advance to anyone able to help.

I need to copy a VLOOKUP formula to a cell underneath but instead of moving the third value (B55) to (B56) which happens automatically, I want the formula to move from (B55) to (C55). Basically moving to the next column, not the next row. How do I make this happen?

I need help using VLOOKUP. So I have my formula, and I know its correct but the problem I'm using a name as the lookup value, and the array I'm using has the same entry multiple times. So when I use VLOOKUP I get a #N/A error. How can I adjust this formula to display any one of the results

I am trying to do a VLOOKUP, the formula seems correct to me, the value I am looking for is in the Table Array, but I get an #N/A result

i need help with a formula that allows me to find the same value in another workbook then enter another value from the row it find the match. i know vlookup allows me to find the match but i dont know how to get the other value after it find the match.