vlook up

In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c). So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s)...

Dear All, I am trying to do a Vlookup with if statement in Power Query but unable to. in Excel I have done in this way --> =IF(P3="Recruited",VLOOKUP(AA3,'Sheet1'!A:B,2,0),) Please if you could help me on how to do this in Power Query? Many Thanks.

Hi All, Extremely sorry that I was not able to upload excel sheet hence had to go with snapshot.. Can you look into it and help me with possible solution. How do I filter unique value and vlookup it in left table? Please advise.

Hi everyone, I'm an excel newbie and trying to figure out how to make something work in VBA. Y'all seem like a really nice bunch, so I'm hoping you can help me out! I've managed to automatically create a pivot table containing days worked per week per person from a raw data file and would like...

So I have 2 workbooks, the first workbook contains a unique ID in a column as well as columns with name, age, skill level, skill name, expiry date in accordance to the unique ID. **NOTE: 1 Unique IDs may have 1 or more skill levels and skill names, different skill level = different row, same...

I have some sets in different sheets. I want to use the match function to be able to use the different names of those sheets by dragging down my formula.

I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...

Hi! Wishing you all a Happy New Year! This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a...

Hello, I need help, If I want to use vlookup but want to retrieve all the data if there is the same data, for example like the following example. If I use the regular vlookup formula it will only take the number "1" but I want to take the numbers "1" and "2" as in column D. Is there a formula...

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

Hello All, I'm looking for opinion for certain task which I need to execute in this table. If you think that can be done with macro or formula. What would be the best possible way. Header2 and Header3 are on different sheet, but that can be adjusted. ABCDEFG1Header1Output which I'm looking...

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

I want to sum if certain cells if the corresponding cell is marked with "Y" and if they are marked with "N" or left blank then subtract the amount in the corresponding cell. I am sure this is not hard to write a formula for but I cant figure out how to do it. Any help would be appreciated!

Hello! I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns. This My Table Table Slicers on Excel Dashboards DEPT Column1 Q1 Q2 BONE & JOINT CENTER left without being seen...

Hi There, (Columns A,B,C below) I need to Vlookup the Column C Value to see if its in Column B. IF it is return the Value in Column A. (This result would be inputted into Column D hopefully) 1234 Frank@gmail.com Susan@gmail.com 567474 michael@gmail.com Jimmy@gmail.com 47474...

Hi Everyone, I'd like to turn an iferror index match formula for one column and a if(change(vlookup in my second column, into just one column. How would I go about do this? My formulas are: This works for finding out new loans by index matching the type to with the current Join concatenate...

Hi there, I am working on creating Excel documents that function as multiple forms going to different people. So the idea is the first sheet in the workbook is the 'Mastersheet' with all of the data arranged in a table. Subsequent sheets contain the forms. Each form contains formulas that...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

Hi sorry for the question but I have been unable to find a clear answer..... Is it ok to use a partial selection of a spreadsheet for a vlookup for example the spreadsheet is 20 columns long the data your matching against is column 5 and the info you want to pull is column 11 is it ok to...

I am trying to loop find tomorrows date in Column H in file "dummy.xls" and every time it finds that date; then copy all the data in that Row into file "final.xls".