“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to create a formula using nested IF functions and VLOOKUP functions. The following formula returns an error message. Please show me the error in my syntax -
=IF(B16="Destroy",VLOOKUP(B14,Dept_Returns,2,FALSE),IF(B16="Return to Mfg",VLOOKUP(B14,Dept_Returns,3,FALSE),IF(B16="Repack",VLOOKUP(B14,Dept_Returns,4,FALSE),IF(B16="Restock",VLOOKUP(B14,Dept_Returns,5,FALSE),"None"))))

Solved by K. S. in 19 mins

HI I need help for vlookup formula. I have two match between my two excel sheets and I don't know how to put them in the one cell with using comma

Solved by X. B. in 12 mins

I have a problem related to Vlookup. Can you help?

Solved by O. E. in 27 mins

I was sent an excel file that has circular references for vlookup in column B, but shows a value in the cell with the vlookup.
The formula in B2 is "=VLOOKUP(A2,Sheet1!$A$2:$B$7,2,FALSE)"
The calculation is set for automatic for the workbook.

Solved by M. E. in 18 mins

USED =IFERROR(IF(VLOOKUP(C2,$I:$I,1,FALSE)=C2,"Close"),"") AND IT RETURNS MOST DUPLICATE FIGURES BUT MISSES SOME - WHY?

Solved by A. C. in 21 mins

iferror(vlookup( formula is not functioning as intended.

Solved by C. H. in 23 mins

I need to put a formula in cell G8 with the HLOOKUP formula with an exact match to return the last name of the operator assigned to the call. And also to put vlookup and hlookup together

Solved by S. F. in 15 mins

Write an HLOOKUP function that will output the correct Net Profit for whichever date is selected in cell H11. Table array is C5:H8
Expert_777

Solved by D. H. in 24 mins

I have some data I wish to sort into a list BUT… in column A are vendor names vertically i.e Tradesmart and then horizontally across the top are individual project numbers in each column.
Horizontally some projects have different costs for the same vendor. What I need to do is get a list which has the vendors in column a and the costs in column B, if the vendor has two projects with costs then it needs to appear twice with the different costs. For example: If Tradesmart has costs in project 1235 and 1245 then it should appear as follows in column A and B as follows.
Tradesmart £50
Tradesmart £60
If I use a Hlookup it will simply pick the first cost it finds for that vendor and If I use a SUMIF it will sum a total under one vendor but I need it split out and to repeat the name if it appears under several project numbers. It could very well be that some vendors only have one cost under one project in which case making a list wouldn’t be an issue. Also one step further would be to put the relevant project number in column C next to the corresponding Vendor and cost. This is simply rearranging the way the data appears but right now I’m having to do this manually and its taking a very long time.
Any help someone can offer would be highly appreciated.

Solved by Z. Y. in 11 mins

How do i use a function within the hlookup function to determine the appropriate row

Solved by B. E. in 13 mins