Check out some problems solved by our top Experts or click here to post your own problem for free!

I used vlookup for my excel sheet to match different cells using another sheet for reference. Now when I try to edit the new cells, it just shows my vlookup formula and wont let me edit anything unless i change edit it from the reference sheet. Wanted to know if i can make it so the cell isn't binded to a formula anymore and is its own cell where i can edit.
Thank you.

Solved by D. W. in 18 mins

I am trying to run a formula that takes a value, and if it appears in both columns on a separate tab, it pulls the difference between the adjacent cells value. I have tried if, match, and vlookup formulas but can't seem to figure it out. Any help is much much appreciated.
Below is small example of what I am trying to run asking if CA9099 it should tell me $1.
So in a cell I put =ifmatch(CA9099, it will take the difference, and if the value doesn't exist in column A on the tab it reads N/A
A B
CA9099 $21 CA9099 $20
CA5674 $20 CA8788 $30
CA8788 $35 CA5674 $15

Solved by S. F. in 39 mins

i have 4 different payment commission options for my sales team. I want to use drop down for them to select which type of cell it is. depending on what they select I want the formula to calculate their commission based on where they finished in the month. My main problem is i can't get my calculation in the vlookup to correspond with which row and cell.
Here is an example of the formula i am working with
=IF(revenueF25<40000,comm!D7*0.22,IF(AND(revenue!F25>=40000,revenue!F25<=70000),comm!D7*0.25,comm!D7*0.28)*10)

Solved by S. Y. in 60 mins

I need my formula to return an empty cell if the data is not found in the Vlookup formula. =IF($C$173=$D$168,VLOOKUP($G$174,'Stip review'!$A:$AY,34,0),IFERROR(VLOOKUP($G$174,'Stip review'!$A:$AY,34,0)="0","C"))

Solved by F. F. in 22 mins

I need a formula where I have to use a vlookup but i am looking at two columns in the table array, if one of the does not have any number in it then I need the the other column to return me an answer

Solved by K. F. in 60 mins

I need to add an formula into this one:
=IF($L$1="","",VLOOKUP(TEXT($L$1,"000000"),'FRS102 BASE & GBP TB MAY 2018'!$E:$X,MATCH(A25,'FRS102 BASE & GBP TB MAY 2018'!$Q$3:$X$3,0)+3,0))

Solved by K. D. in 11 mins

hi. i need a help on vlookup formula . i need to create a excel please help me

Solved by F. W. in 27 mins

So I have used vlookup to find the price of a product on a different sheet and then I have tried to times that by a quantity.
e.g. =vlookup(d4,table35,2,false)*e4
This is the formula I typed in which worked for another list I did but for some reason it's not working now even though everything is practically the same, apart from the contents. Could you help?

Solved by B. U. in 60 mins

My VLOOKUP formula won't work when value the "lookup cell" is derived from a formula. If I manually transfer the formula derived value to a different cell, then VLOOKUP formula works fine. What's going on?

Solved by Z. J. in 40 mins

i need vlookup formula how can i use in diff sheets

Solved by B. B. in 60 mins