look up value

Hi Guys, I have 2 workbooks on my deck namely Project (source file) and Reference (vlookup reference file). In Project workbook, I need to look for the Value of F in Reference Sheet column B and populate it in G column. Project Workbook: I was able to populate the data in column G using...

Hi there! I have a large spreadsheet and I managed to use conditional formatting to make certain rows (when a cell in column G had a value > 1000) turn red. That caused me to have a large spreadsheet with certain rows red; however, is there a way to use vlookup or any other lookup function to...

Hi all, My data as following.. Column A will have names. A1 : alex A2 : steven A3: Josh A4: Josh A5:Josh Column d will have time. A1: 2pm A2:3pm A3:1pm A4:3pm A5:5pm On another sheet, I have the names column a First cell a1 is Josh. I want to return in cell b2 5pm then cell b3 1pm...

Hello all, I'm working on a userform and am setting up some insurance the users enter the required data. I have a three text boxes: tbMaterial, tbQty and tbCost. There is a index match function for tbMaterials that fills in the cost if its a material we already have the price for. If we do not...

Hi there, I am trying to understand the formula here. The function of the formula is to look up unique values from a column. The match function here has no look up value. Could anyone explain it a little to me? Does there have sth to do with the fact that it is an array formula...