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

Need help with IF, MATCH, and excel LOOKUP function. Need to crosscheck 2 columns and once a match is found, return a value from the neighboring column.

Solved by Z. H. in 19 mins

i would like to apply vlookup.
if there is 1 pc in transit and 2 pc in pending then result should be ETA date in 1 pending line and "No ETA" in second pending lines.

Solved by G. D. in 14 mins

When I do a vlookup and then copy the formula it copies the same result in the remaining cells. What do I need to do to have the actual result listed? thank you.

Solved by S. H. in 17 mins

I would like to have a cell look up a value on another sheet in a workbook and if the number is there and is greater than 0, then have the cell say "Yes." If the value is not there/is blank, then have the cell say "Budgeted Cost." Please find the formula I am currently using, below"
=IF((VLOOKUP(B39,Tracker!$A$3:$N$200,14,FALSE)>0),"Yes","Budgeted Cost")

Solved by E. H. in 19 mins

Hi,
I have a sheet which is using VLOOKUP to get data from a salary field linked by an ID number which is on another sheet associated with the salary
The problem I have is that we have multiple entries (rows) which have the same ID field so we essentially only have one row which displays the salary linked to the ID number but the others don't fetch the salary.
What I want to do is have a formula which is basically 'IF the ID number matches the ID number of the row with the salary field filled in THEN copy the same salary to the empty fields on the other rows.
To visualize:
ID | Salary (fetched by VLOOKUP from ID)
1 | £100
2 | £110
3 | £105
3 |
3 |
4 | £120
5 | £150
As above the VLOOKUP doesn't fetch if the ID is the same (as the other sheet has only one instance of the ID)
So I was wondering how to get excel to display the right number (£105) in the blank spots
Thanks in advance

Solved by V. S. in 17 mins

I would like F17 to pull value from 'Tracker' sheet if G17 says "yes". If G17 says "Budgeted Cost" then I would like F17 to pull value from (=IFERROR(VLOOKUP(C17,'Unit Renovations'!$C$6:$E$11,2,FALSE),""))

Solved by E. A. in 12 mins

Q20 has a date that does not exist. I would like the formula: "=IFERROR(VLOOKUP(B20,MRB!$D$3:$AP$300,38,FALSE),"")" to leave the cell blank if the date does not yet exist. And if G20 says yes, I would like the entire row from B to S to hard code the numbers, that way they do not change in the future. Or is that even possible? Thank you so much! I cannot believe that I have not used your service before! I have spent hours on this worksheet and you guys resolve errors within minutes! So fantastic!

Solved by F. B. in 29 mins

I am using vlookup and between two sheets.I have converted the field to numbers ,but whenever i use the formula,I get #NV error

Solved by T. U. in 18 mins

Hello, the Master Tab pulls in data from specific cells in other tabs. Instead of typing in the cell location (e.g., H2), is there a way to use vlookup or hlookup to ID which specific cell to pull in?

Solved by C. H. in 18 mins

hello
I want to make a time sheet in excel for the company employees
its attached
I don't want to create a separate file for each employee then multiple sheets in each file for each month
I saw some files online where you create a drop down list for employees then whenever you choose an employee you get his own data in the same sheet
is this related to conditional vlookup and can only be applied when the changes between employees data are only in formatting?
is it related to VLOOKUP?
I also want to apply the same concept to years/months so I can stay in the same sheet while viewing the details for all employees for whatever year or month I want
thanks

Solved by T. S. in 29 mins