Are you stuck on Excel or Google Sheets?

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.

I need an excel formula for following.I need to retreive Dates based on CarModel Id .look up the id and retrieve dates.When i retrieve dates i want to retrieve blank values if any.Currently i am using the formula Text(VLOOKUP (),"MM/DD/YYYY") which inserts 1/9/1900 instead of blanks.

im trying to make a formula to where it will pull a value from a different sheet. i have tried looking up index and vlookup but i cant get them to work properly and not sure what i am doing wrong

Hi. Been on this problem for days now. Here is the formula I have managed to come up, it works ok and does what I need but I need the D3 and E3 to be referenced in the same way as the FEE_Table as when I . For instance when I select a value from the data validation list in Y2, if the value in AA2 is blank it returns value from Postage!D3, but if not it returns value from Postage!E3. These D3 & E3 values are in the same FEE_Table. So am hoping there is some way I can include in the IF function another Vlookup which chooses the value I want. Any help would be much appreciated. Thanks =VLOOKUP(Y2,FEE_Table,4,0)+IF(AA2="",Postage!D3,Postage!E3)

I need help with a vlookup type formula that will take a given name and reference it against a list of names in columns D-O. then take a given date and reference it against dates in columns A10-A440, then return the cell or its contents at the intersection of those that column and row.

I need help with a VLOOKUP formula. How do create a formula.

I have three columns on a spreadsheet. The first two columns I need sorted so that it includes everything 80% and greater. The third column I also need 80% or greater but this column is a result of a VLOOKUP formula.

hi, I want to do a vlookup, but look up one reference, but lookup from 8 different columns to bring back data from another column, then drag the formula to bring up the rest of the data from another column

hi can you help me out with the vlookup formula